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

    Selection of field with If condition

    Renu Raghav

      Hi All

       

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

       

      CBSDesc = 'TRANSFER OF FUNDS #239983'

      CBSAmount<1


      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.