I had to use a messy ISNULL() with LOOKUP in order to identify nulls in a formula, as suggested by Jonathan Drummey in this thread. (ifnull(IIF(isnull(LOOKUP(SUM([EOP]),0)),sum([EOP 3),0),0). I got it working as far as the measure detail is concerned, but now the Grand Total isn't working:
I can't change the operation to Sum from Automatic since the formula is now a table calc and Sum is grayed out:
.
Frustratingly, the column header tooltip IS displaying the correct total!
Is there any way to actually display that amount? The field is already in Measure Values. I also can't figure out a way to substitute an LOD for the above formula.
I am interested in displaying the correct Grand Total, open to any suggestions. Thank you!
3 respostas