ISNULL function

[#1]

Hello Fellow users,

I have a problem with the following statement, cann someone help me, here it comes.

I have three fields FOB_BILLING , FREIGHT_EST, RESULT. I would like to write the following formula:

If (FOB_BILLING <=0 then Field RESULT should be 0.

iF(FOB_BILLING >0 then Field RESULT Should have the value of FREIGHT_EST .

I tried the following statement:

IF(ISNULL(FOB_BILLING)= '0', FREIGHT_EST,'0') as RESULT,

Greetings from Holland,

Aissam

[yblake]

let's try :

IF(IF(ISNULL(FOB_BILLING),0,FOB_BILLING) > 0, FREIGHT_EST,0) as RESULT,

[#3]

Thanks Yves,

It works,

Merci beaucoup,

Aissam

[#4]

I don't understand why you should need the ISNULL() function for this problem, I would fix it like this:

IF(FOB_BILLING>0,FREIGHT_EST,'0') AS RESULT

Otherwise like this:

IF(ISNULL(FOB_BILLING),'0',IF(FOB_BILLING<=0,'0',FREIGHT_EST)) AS RESULT

[#5]

This works also.

Bedankt,

Aissam