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

Essbase IF ELSE Calc Script Error

Received Response
14
Views
3
Comments
edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

Essbase IF ELSE Calc Script Error

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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