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

Calculation Logic

Received Response
edited Aug 2, 2018 2:36AM in Essbase 4 comments


Calculation Logic


Hi All,

I am writing a Business rule in PBCS with the below logic:

Suppose its a budgeting cycle and user needs to enter the budgeting numbers from JUN to DEC for FY17. Now instead of entering user can run a BR which will equally distribute the value of BegBalance (in Period dimension) to Jun to Dec.....It can be from OCT to DEC as well depending upon Budget cycle.

I wrote the code something like that

Var TempVar;

FIX ("Budget")



IF(@CalcMgrCompare(@NAME({SourceYear}),@Name(&ActYear),@_true)) /*This line is checking the budgeting year is current year or future years*/

Howdy, Stranger!

Log In

To view full details, sign in.


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