Skip to main content

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:

 

How to display 

I can't change the operation to Sum from Automatic since the formula is now a table calc and Sum is grayed out:

 

Sum is unavailable .

 

Frustratingly, the column header tooltip IS displaying the correct total!

 

Tooltip's "Sum of Measure Values:" has correct Grand 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 answers
0/9000