Essbase IF ELSE Calc Script Error
Summary
Essbase IF ELSE Calc Script ErrorContent
Hi,
I'm trying to build a complex IF ELSE calc script to meet our goals. I'm pasting the calc script without RTSV commands since it's an RTSV Calc Script. The syntax is correct, but somehow the logic is not working correctly.
Is there any error in my script?
Thanks,
FIX(&Period, &Project, &BUDGETCATEGORY, &Position);
"Base"
(IF(BUDGETCATEGORY=="510006")
IF(@ISUDA(Position,"10"))
IF(@ISUDA(Period,"1"))
IF(Override_Daily_Rate->BegBalance->No_Project->&Position > 0)
"Base" = (Override_Daily_Rate->BegBalance->No_Project->&Position)*((Fringe_Percentage->BegBalance->No_Project->&Position)/100);
ELSE
"Base" = (Daily_Rate->BegBalance->No_Project->&Position)*((Fringe_Percentage->BegBalance->No_Project->&Position)/100);
0