IF condition for <>Null

[renuka_sasikumar]

Hi,

I have Sales Data where I want to have Sales_Value under the condition

WHERE SALES_OFF<>Null

SALES_GRP<>Null

& Division<>XYZ

How can I get the Value.

I tried by this at Scripting Level as well as in Front END but its not working.

=if(SALES_GRP<>' ' AND SALES_OFF<>' ' AND Division<>'XYZ',Sales_Value )

Can anyone plz help me.

Thanks & Regards,

Renuka

[tresesco]

Try like:

if( Len(Trim(SALES_GRP))=0 AND Len(Trim(SALES_OFF))=0 AND Division<>'XYZ',Sales_Value )

[jvitantonio]

Hello,

You can try this:

if(NOT ISNULL(SALES_GRP) AND NOT ISNULL(SALES_OFF) AND Division <> 'XYZ', Sales_Value)  AS Sales_Value;

JV

[jagan]

Hi,

You can use

if( Len(Trim(SALES_GRP))=0

OR

If(Not Isnull(SALES_GRP))

Hope this helps you.

Regards,

jagan.