if(isnull) statement

[#1]

Try to use this formula but i'm getting 'Error in Expression: If takes 2-3 parameters'

Help me with this to work properly.

if(isnull([SHIP_DT]) = false and isnull([P_RETURN_DT])=false) then

(sum(([SALE_RPRICE])*([ORDER_QTY]))*(-1));

else if(isnull([SHIP_DT])=false and isnull([P_RETURN_DT])=true) then

sum(([SALE_RPRICE])*([ORDER_QTY]));

else

'0';

end if

Thank you

[sushil353]

Try this:

if not isnull([SHIP_DT])  and not isnull([P_RETURN_DT]) then

(sum(([SALE_RPRICE])*([ORDER_QTY]))*(-1));

else if not isnull([SHIP_DT]) and isnull([P_RETURN_DT]) then

sum(([SALE_RPRICE])*([ORDER_QTY]));

else

'0';

end if

[#3]

Thanks for the reply,

but i'm getting 'Grabage after expression: 'not'

[sunny_talwar]

How about this?

If(Len(Trim([SHIP_DT])) > 0 and Len(Trim([P_RETURN_DT])) > 0, Sum(([SALE_RPRICE])*([ORDER_QTY])) * (-1),

If(Len(Trim([SHIP_DT])) > 0 and Len(Trim([P_RETURN_DT])) = 0, Sum(([SALE_RPRICE])*([ORDER_QTY])), 0))