TM1 Forum

David Usherwood wrote:What's the business problem you are trying to solve?

Hello David,

OK. Like you said you are correct. I've changed the first line within rule. I've defined different column except "Net Kar". it works.

Kind regards,

David Usherwood wrote:But you set Net Kar in the first rule and you can't then change it later - in fact your later rules only affect Net Zarar anyway. Be clear - Rules are declarative not procedural - once a rule applies that's it.

Ok. How can I modify my rule? I'm a few confused.

Thanks & Regards,

Your first rule sets Net Zarar based on Net Kar being positive, if not the second rule applies. Net Kar won't be affected by either rule as it's set in the line above. Remember rules are declarative, not procedural (like Excel formulae) - the first assignment which applies is the one which is used....

Hello, I've been using TM1 10.2.I'm newbie. I have a problem related to the if function. Here is my rule : ['Brüt Kar' ] = (DB('Satýþ ve Maliyet', !Aylar, !products, 'Satýþ', !Senaryolar, !Yýllar, !Ülkeler, !Stroes) + DB('Satýþ ve Maliyet', !Aylar, !products, 'Maliyet', !Senaryolar, !Yýllar, !Ülkele...