9 Replies Latest reply: Feb 24, 2016 9:09 AM by Sangram Reddy RSS

    Selection of field with If condition

      Hi All


      I want to pick one value in negative using set analysis with this condition where


      CBSDesc = 'TRANSFER OF FUNDS #239983'


      then I want the result. This condition is not working in KPI

      IF(CBSDesc = 'TRANSFER OF FUNDS #239983' AND CBSAmount<1, sum({$<CBSDesc = {'TRANSFER OF FUNDS #239983'}, 0)


      Could you please help with this.