TM1 Forum

Hello,

I would like to make a colum rule like = 'If the value in a cell is under 30, change the value to 30'.
Tried something like: ['columnA'] = if([columnA]<30,[columnA]=30,continue);

Apparently this is a recursive call and the the rule never ends...

But how can I do this kind of calculation?

Thanks a lot,

Toto

You could use the DB function to check the value in a cell within the same cube:

example:
['columnA'] = N: if(DB(cubename, e1, e2)<30,30,continue);

Got it, thanks a lot!

Toto

I'm pretty sure this will still create a circular reference

['columnA'] = N: if(DB(cubename, e1, e2)<30,30,continue);

If cubename is the same cube you are writing the rules in

Since at run time either !e1 or !e2 will resolve to 'coulmnA'

The way you have written your rule there's no way to do this (with rules) in TM1.

Is more correct

['columnA','measure2'] =N: if(['measure1']<30,30,continue);

The only way to get the results in the same cell as you are testing would be to process the dataset through TI, but then it would not be live.

HTH