if stmt

[raadwiptec]

I need to have something in the script like the below -

IF len (product) < 0 and isnull(product) then costprice else saleprice

any suggestions

[BalaBhaskar_Qlik]

=IF((Len(Trim(product)) = 0 or IsNull(product)), costprice, saleprice)