tips for writing rules

[charan]

hi,
I am begineer in TM1, i am working on rules, i have worked on rules which i got from higher collegues and able to do it. when i am tryong of my own rules with developing new models or cubes and writing rules for it, i am always getting error like"Invalid statement with the particular element with the element i have developed" Can give me suggestion for executing the rules correctly.
Example i have developed....
with dimension rule1 with profit,loss, s.p,c.p.
with dimesion gross profit, margin.
rule is..
margin=profit*loss;
when i write this rule i got the error loke invalid statement.
Give some suggestion to correct my self and to get it.

Thanking you very much.

TM19.5
excel 2007.

[comma]

Element must be written using square brackets and apostrophes:

Code: Select all

['margin'] = ['profit'] * ['loss'];

[tomok]

The Rules editor has a wizard-like interface for helping you with the syntax. Why are you not using this?

[charan]

Boss,
Thank you, i have done what you told me.The mistake i done was i used feeder symbol in the rule.

Thank you very much.