TM1 Forum

All,

I am trying to feed the following rule with the following feeder.

Skipcheck;
['LC AMT']=N: IF(ATTRN('Account_CF', !Account_CF, 'Class ID') = 45, ['LC AMT'] * -1, CONTINUE);

Feeders;
['LC AMT'] =>DB(IF(ATTRN('Account_CF', !Account_CF, 'Class ID') = 45), ['LC AMT'] * -1), ['LC AMT']);

When saving the rule I receive the following syntax error on line 37 which is the feeder statement line.

Any help that can be provided will be greatly appreciated.

---------------------------
Xcelerator Error
---------------------------
Line 37: Syntax error on or before:
), ['LC AMT'] * -1),
missing comma
Rule could not be attached to the cube, but changes were saved.
---------------------------
OK
---------------------------

Hi
Your rule basically says
['LC AMT'] = ['LC AMT']*-1;

That is not ever going to work because it is a circular reference. Let alone that the Feeder would have to be

['LC AMT']=> ['LC AMT'];

You get my drift?

If you have a working rule, post that exactly as it is in the rule editor and people can help you.

Thanks. Yes, I get your drift. I need to create another measure to basically perform the flipping of signs for certain account classes. That makes sense now that you pointed it out.