I have set up a roll up analysis that shows a result "Calc Failed". (See Shift TRSp below)
However, when I check the calculation on the Analysis tab for the element, I get a value.
The value that is being rolled up is the result of an expression analysis which uses an If statement.
I'm not sure if the If statement has an impact on the roll up analysis.
There are 5 of these calculations being rolled up.
Can anyone help with why this calculation is failing?