Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Where is the problem with this syntax? Please accept my sincere thanks
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)))
I think you were missing an If statement. I've added that and reformatted so that you can check the logic.
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)
)
)