TM1 Forum

I want to put a flag=1 for the following accounts and companies.

What feeder should I put ?

['Flag']=N:IF(ELISANC('account','X000000',!account)<>0,IF(ELISANC('company','AUS',!company)<>0,1,0),0);

Thanking you in advance

You can't write a feeder for that without seriously overfeeding. I'd suggest one of two different approaches.

1) Create an attribute called Flag against both of the dimensions and either populate the data manually, or write a rule in the attributes cube without skipcheck of feeders.
2) Don't have a Flag field. Instead use the if statements you've written below but nest them in the calculation that you were intending to use the Flag field for.

Personally I'd go with 1.

Martin