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

Simple logical calculation of budget transfer

Accepted answer
41
Views
9
Comments

The below code is supposed to run in a second or two but it's running for 20-30mins and giving wrong results. It's filling all the cells. I checked and we have 10 dimensions in our FS cube and all of them are present. Not sure why and how it's still going out of range.

SET UPDATECALC OFF;

SET AGGMISSG ON;



FIX ("SAR", "OFS_Direct Input" , "Approved_Bud", "FY24", "No Miscellaneous")


    "OEP_Plan" 

    (

      IF (({V_Account_Source}->{V_Project_Source}->{V_Entity_Source}->{V_Period_Source}) - {V_Amount} <= 0)

        @RETURN("There is no enough budget available to be transferred from this source combination", ERROR);

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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