IF statemnet and equal sign (=)

vargabor · Oct 18th 2007, 3:45pm

If I write an IF statement in Palo I can't use an equal sign (=) in the logical test part of the statemnt only the following characters:

!=
>
<
<>
><

I haven't found anything about this phenomenon in the rule writer guide.

Rule:
['menny_pal','varhato'] = N:if(value(right(palo.data("varga_sales","PREMISSZA","honap",!'ev',"varhato"),2)) >= value(!'ho'),['menny_pal','teny'],if(palo.data("varga_sales","#_vevo","terv_tip",!'vevo') > 1,stet(),if(palo.data("varga_sales","#_vevo","terv_tip",!'vevo') = 1,

palo.data("varga_sales","FORG","menny_pal",!'vevo', !'cikk', concatenate(!'ho',"YTD"),!'ev',!'telephely', !'verzio')

/ palo.data("varga_sales","MEGOSZLAS","megoszlas",concatenate(!'ho',"YTD"),!'vevo'),0)))

zprof · Oct 18th 2007, 4:17pm

Hello Vargabor,

try to use IF(eq(Statement1,Statement2),THEN,ELSE)

or

IF(Statement1 == Statement2),THEN,ELSE)

I hope it helps you.

Regards

ZPROF

h_decker · Oct 18th 2007, 4:24pm

Hi,
= wont work, use ==

Holger

vargabor · Oct 18th 2007, 4:25pm

Thanks for your fast respons, I'll try it.

Pommie · Nov 8th 2007, 11:08am

Out of interest why do we have to use == instead of the normal =

Seems very odd to me

Stephanie · Nov 8th 2007, 6:36pm

Hello Pommie,

Here you find a good explanation for this.

Regards,
Stephanie

Pommie · Nov 12th 2007, 10:02am

Thanks Stephanie - so are you saying that in Palo a test that says "if x == y, then z" means "test if x = y, and if x is not zero, execute the statement following" as opposed to simply "test if x = y and then execute the statement following"?

Stephanie · Nov 14th 2007, 10:28am

Hello Pommie,

Sorry, I guess this link was more confusing than it helped.
Using the IF-statement needs "==" for testing equality and normal
"=" won't work as it stands for assignment.

"test if x = y, and if x is not zero, execute the statement following"

This therefore won't work.

Regards,
Stephanie

Pommie · Nov 14th 2007, 7:55pm

Clear now - Thanks

I think your average Excel user (the target of Palo surely) would be hapier with an = rather than an == however "correct" == might be in strict syntactical terms.

Tm1 uses some pretty weird stuff for logicla comparisions but at least it has just =

Pommie · Mar 20th 2008, 3:03pm

Can I just confirm whether in PALO

!=

means NOT Equal to

J

wilhelmus7 · Apr 3rd 2008, 3:05am

Hi John, hope you're not jumping ship permanently!

Yep, != is not equal to.

I think it originates in C. It's also used in PHP and a few other languages.

Martin Ryan

Pommie · Apr 3rd 2008, 8:36am

Hi Martin - Thanks

You know what they say about rats

On a serious note I am extremely impressed by what these guys have done here and I think it's only going to get better!

wilhelmus7 · Apr 8th 2008, 6:13am

Yes, I like what they're doing too. I'm in the midst of an implementation at an SME firm and they love the price tag. I'm pretty happy with the functionality too.

I wonder what the revenue model is though - waiting for Microsoft to come and buy???

Pommie · Apr 8th 2008, 8:17am

I suppose the buy out scenario is an obvious one, but it's a different model entirely isn't it?

I imagine that if (as it will) it gains traction, then a few thousand x the annual support fee would make up for a few dozen x an inflated licence cost.

IF statemnet and equal sign (=)

IF statemnet and equal sign (=)

RE: IF statemnet and equal sign (=)

RE: IF statemnet and equal sign (=)

RE: IF statemnet and equal sign (=)

Share