Report Definition - customize output (similar to Oracle "decode" statement)

General
,
1

Assume I have the following data:

Data 1, New, 150

Data 2, Resolved, 322

Data 3, Resolved, 543

Data 4, Removed, 231

I would like the following (if col2 = Resolved, then display 0 in col 3)

Data 1, New, 150

Data 2, Resolved, 0

Data 3, Resolved, 0

Data 4, Removed, 231

How can this be accomplished in the Report Definition Rule?

2

@MichaelB9860

This can be achieved using function alias. Please refer the attached document.

Report Definition - customize output (similar to Oracle .docx (280 KB)