Question
   Booz Allen Hamilton   
  Booz Allen Hamilton
US
   Booz Allen Hamilton   
  
          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?