10 Replies Latest reply: May 14, 2018 1:45 PM by Archana handu RSS

    set analysis fro not null values

    Archana handu

      I'm writing  set analysis for total charges where charge id is not null.

       

      Sum({<[Charge ID]-={"' '"}, REVENUE_DATE={"<= $([REPORT DATE]) "}>} TOTAL_CHARGE_AMT)

       

      but it doesn't seems to work . it gives me same result as sum(TOTAL_CHARGE_AMT). which is not right .

       

       

      Any help is highly appreciated.