8 Replies Latest reply: Dec 6, 2016 9:30 PM by Sunny Talwar RSS

    Set Analysis using an If

    Cliff Clayman

      I am trying to use the following set analysis expression:

       

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

       

      What I am trying to do is get the Sum of [A] + [B] when Division = 'B' and FY = vFY and if it does not, then get the Sum of [C] + [D].  The current expression is not valid.  How can I write this?