Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Calculation Issue in Business Rule — Cloud Customer Connect
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 Issue in Business Rule

12
Views
2
Comments
in Planning 2 comments

Summary:


Content (required):

Hi Experts,

In our implementation, we are having 9 dimensions as Years, POV, Time Periods, Version, Scenario, Account, Product, Cost Centre, Group. In which we need to copy some data entered in the below combination to copy across descendant values specified in the rule FIX.

Example:

Value is in the combination of

Group -L000,

Cost Centre - C000,

Product - P000,

Time Periods - Jan,

POV - Monthly,

Years - FY21,

Account - AWDR 1 Month - Benchmark,

Version - Draft 1,

Scenario - Budget,


The rule is written as follows,

FIX(FY21,Budget,"Draft 1",@Relative("All Cost Centre",0),@Relative("Region 9",0),@Relative("All Products"),Monthly,@IDESCENDANTS("Time Periods",0))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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