Calculated Dimension value different to Expression value

[#1]

Hi,

Can anyone tell me why I get two different sets of results when I use the same formula as both a Calculated Dimension and an Expression?

Here is the structure of the formula:

if(AuditUpdateID=aggr(num(max(AuditUpdateID,2)),AuditUpdateID,ID),FinancialValue, NULL())

The Calculated Dimension appears to be functioning correctly while the Expression is missing a number of values.

Thanks,

Alan

[jonathandienst · Accepted solution]

Alan

Possibly because the expression is being influenced by other dimensions on the object, whereas the dimension is not?

Jonathan

[#3]

Thanks Jonathan.