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.