Cross-dimensional member value in IF Statement Error

@RELATIVE(PROJECT

Summary

Cross-dimensional member value in IF Statement Error

Content

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;)