Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
what is wrong with this syntax? thanks in advance
IF( ISPROJECTMAINORDER = '-1'
AND
ordercategory_code = '100'
AND
(sum(Total_cost_price_pbd) > 0.0), Total_cost_price_pbd,
(ISPROJECTMAINORDER = '-1'
AND
ordercategory_code = '100', TOTALNETAMOUNT * 0.65,
sum(SO_costprice)))
If(ISPROJECTMAINORDER = '-1' AND ordercategory_code = '100' AND Sum(Total_cost_price_pbd) > 0.0, Total_cost_price_pbd,
If(ISPROJECTMAINORDER = '-1' AND ordercategory_code = '100', TOTALNETAMOUNT * 0.65, Sum(SO_costprice)))
If(ISPROJECTMAINORDER = '-1' AND ordercategory_code = '100' AND Sum(Total_cost_price_pbd) > 0.0, Total_cost_price_pbd,
If(ISPROJECTMAINORDER = '-1' AND ordercategory_code = '100', TOTALNETAMOUNT * 0.65, Sum(SO_costprice)))