9 Replies Latest reply: Oct 11, 2016 6:53 PM by Sunny Talwar RSS

    How to filter out zero dollar values in a Sum using Set Analysis

    Cliff Clayman

      I have a set analysis expression that calculates the Sum of the value Amount:

       

      =Sum({$<[FY]={$(vFY)}, [Division]={'A','B','C','D','E','F'}>} [Amount])

       

      I do not want to see the values that are equal to $0.00  How can I filter those out?