Cross-dimensional member value in IF Statement Error
Summary
Cross-dimensional member value in IF Statement ErrorContent
Hi,
I trying to create a Calc Script something like below and instead of using "510002"(it's an account member), I want this script to calculate for an account which users enter manually using SmartView under ACCOUNT_NBR (i created a member in Accounts dimension to grab which Account number they want to run this script for)
FIX(@RELATIVE(PROJECT, 0), @RELATIVE(POSITION, 0), @RELATIVE(Sandbox, 0),@RELATIVE(PERIOD, 0), "FORECAST");
"510002" ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->>>>I want something like THE DATA VALUE in this intersection (ACCOUNT_NBR->BEGBALANCE) FOR EACH POSITION, PROJECT and SANDBOX
(IF ((CALCULATE->BEGBALANCE) == 1)
"510002" = 25;
ELSE
"510002" = 50;
ENDIF;)