You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to use @SHIFT(@CurrMBR in a crossdim

I am trying to write a calc in calculation manager which will return a different value based on 3 different situations depending on the Period (i.e. "Jan") in the IF statement. In the example below, for the second situation (Period is Feb:Nov), the value for account "50001" should equal the value of account "Total_Billed" for the prior month. The calc is not working. I think the issue is in the syntax of the cross dim. Any help would be appreciated. Thanks.

My calc looks like this:

FIX (@RELATIVE("YearTotal",0),"Budget")
"50001"
(
IF(@ISMBR(Jan))
"50001"="Fees_Billed"->"BegBalance"*0.5;
ELSEIF(@ISMBR(Feb:Nov))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!