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

Received Response
31
Views
6
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!