10 Replies Latest reply: Feb 14, 2012 6:57 AM by Rainer Filoda RSS

    Exclude Sales Orders based on Cost Category

      My data in QVD looks like below:

       

      Sales Order    Cost Category     Values

      1000               A                        100    

      1000               B                        200

      1000               C                        300

      1000               D                        400   

      2000               A                        100    

      2000               B                        200

      2000               C                        300

            

       

       

      If the Sales Order has Cost Category D then my report should not show Sales Order 1000. My report output should only show data for sales order 2000.

      I tried following calculated dimension with following syntax but its not working:

      = if(Cost Category = 'D', null(),Sales Order)

       

      Any help is appreciated.