TM1 Forum

Hello All,

I want to do a calculation as below:I know that the below calculation creates a circular reference but please let me know if any other option i can use!

['Min Sal']= N:['Min Sal']+ 20(inputvalue);

I mean i want to increase the Min Sal based on the input value or value from another lookup cube.

Please suggest me the option to do the calculation to increase the 'MinSal' based on input value or from a lookup cube?

Thnaks, Sri

If you absolutely need the value in a cell to change based on what was already there you will need to use a TI instead of a rule.

If you absolutely need to use a rule you will need to introduce an extra measure element e.g. ['Min Sal'] , ['Min Sal Adjusted'] and ['Input']
with ['Min Sal Adjusted']=N: ['Min Sal'] + 20['Input'] ;

Not sure how big of a change it would be in your application, but I generally prefer to do these type of things in a consolidation.

MinSal
MinSalInput
AdjustmentValue

The consolidations quicker for TM1 to perform then rules so I prefer to use consolidation whenever possible for simple math issues.

Thanks for the responses declanr and George.
I am just wondering if i want to do the below calculation as per your logic:

['AdjustmentValue'] =N: ['MinSal'] * (['MinSalInput']/100);
as i need to add the MinSalInput as a percentage of Min Sal.
Procedure:
AdjustmentValue -- Consolidated element
MinSal and MinSalInput are children of AdjustmentValue
Do i need to change the weight value for MinSalInput in element properties to get the percentage?

Thanks, Sri

Contd....

with Rule below?
['AdjustmentValue'] = C: ['MinSal'] * ['MinSalInput']/100;

Is that Correct or i dont need to write any rule?

Thanks, Sri

Contd...

With Feeder below:
['MinSalInput'] => ['AdjustmenValue'];

Thanks, Sri