Question
Booz Allen Hamilton
US
Posted: Aug 10, 2023
Last activity: Aug 10, 2023
Last activity: 10 Aug 2023 16:04 EDT
Solved
Report Definition - customize output (similar to Oracle "decode" statement)
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?