0 Replies Latest reply: Oct 31, 2016 1:24 PM by Matt Maino RSS

    Two set analysis expressions in one expression

    Matt Maino

      Hi,

       

      I am trying to implement the below logic into an expression in a pivot table. For one subset of my data I'd like to sum  the "Current Balance" field for a different "Production Date" than the other set. The problem is that they do not sum together in the end. Is there anything that I can add to the logic that would allow these to add together in the pivot table?Is an if statement the way to go for this or is there a better way?

       

      if([Toggle]= 'Yes'

      , sum({$<[Production Date]={"=2016-04-29"}>} [Current Balance]/1000)

      , sum({$<[Production Date]={"$(=date(max({1<Year={$(=max(Year)-1)}>} [Production Date])))"}>} [Current Balance] /1000), )


      Thank you.