IF and IsNull function

[Anonymous]

I'm trying to add an IF-function in the script:

IF (IsNull () and IsNull (), "Yes", "No")

The script says that the formula is okay, but it doesn't show the desired result.

Who can help me to discover the error in my formula?

[shashipraband]

Hi Natascha,

It is working for me, I tried this using the inline table for the example you mentioned above.

I defined null as blank in below script.

Input:

Set nullinterpret='';

Load *, IF (IsNull (A) and IsNull (B), 'Yes', 'No') as NullValue;

Load * inline[

A,B

A Value,A Value

A Value,

,A Value

,

]

Output in front-end:

Note: Please check you may be assuming a blank value as null, but it may not be true always. It may be an empty string. So if it is a real null value(not an empty string) then if you click on it, it should not get selected and no changes should happen. And one more observation you can do is null values will not visible in list box. Just check.

Regards

Shashi

[Anonymous]

Same result as by using the other formula, but thanks for your help.

[sasiparupudi1]

Please provide a sample app.

[vishsaggi]

Can you share exact expr you are trying to use in your app? With some sample data would help.