Complex Nested IF syntax needed..

[Anonymous]

Hi,

I wanted to use this formula in QlikView script but it is throwing syntax error as it is a complex nested IF !!

Please help

Formula:

if (Invoice_Date > 0 ) { (SQ *USP * AR_Exchange_Rate) + Freight_USD }

else { ( Order_Return_Quantity * Unit_Selling_Price*  Return_Exchange_RATE)  + Freight_USD

if (Nvl ( Order_Return_Quantity, 0 )==0) {0} }

[Anonymous]

This worked!

Thanks