Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Alan
Possibly because the expression is being influenced by other dimensions on the object, whereas the dimension is not?
Jonathan
Alan
Possibly because the expression is being influenced by other dimensions on the object, whereas the dimension is not?
Jonathan
Thanks Jonathan.