IF-Rule with false Value "no rule execution"

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Calle

Intermediate

Posts: 8

Date of registration: Nov 14th 2009

Location: Germany

Thursday, May 13th 2010, 3:38pm

IF-Rule with false Value "no rule execution"

In an IF-Rule I always have to set a true value and a false value. Is there a possibility to create a rule "IF condition is true do X else do nothing"? I want to write forward the inventory from the previous month to the next month. For the first month I dont have a previos value, so I want to fill in a start value for each product manually. With my rule I only can create ONE start value for all products.

['AB UE/FE'] = N:IF((!'Monat') == PALO.EFIRST("DeltaAG","Monat"),200,PALO.DATA("DeltaAG","Deckungsbeitrag",!'Produkte',!'Jahr',PALO.DATA("DeltaAG","#_Monat","Vormonat",!'Monat'),!'Datenart',!'Organisation',"UE/FE"))

Is there a possibility to set the rule out of order for the case the condition is false (or in this case the condition is true) and fill in the value manually?

Thanks for your help!

Go to the top of the page

realquo

Sage

Posts: 255

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

Thursday, May 13th 2010, 4:00pm

Yes,
in the place of the rule when you want to put the "do nothing", just put STET()
i.e. IF(condition, if-true value, STET() )

When Palo encounters a Stet() command, it passes to evaluate the next rule.

Regards,

RQ

Go to the top of the page

Calle

Intermediate

Posts: 8

Date of registration: Nov 14th 2009

Location: Germany

Thursday, May 13th 2010, 7:25pm

Thanks, that works well

Go to the top of the page