Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I want to move the calculated part or leafname=FieldA, of the calculated dimension of: if(leafname=FieldA,ProfitDim) to the expression
I've tried just adding in leafname=FieldA, as a line of the expression and changing the dimension to ProfitDim but its not working. Any ideas?
Here you go, i show how i originally used a calculated dimension, how i used a work-around loading the dimension in the script, and what I tried for getting the calculation into the expression.
Regards and thanks so much for any help!
Brandon
Hi,
I am not sure if I understood your problem but may be you mean changing the expression like below:
-1*sum({ $< balcode3={'ACTUAL'},
LinkYear={$(=ONLY("CurrentDocumentYear"))},
LinkMonth=CurrentDocumentMonth3,
[code3]={'DEPTSTMTSACT'}
>} if(leafname=el3,Tot3))
So, I just moved the IF stament from Dimension (dimension is now GL_Account_Number_Name_Profit_Loss3) to Expression (right aroung Tot3).
regards,