Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Simon4
Creator
Creator

What is wrong with this syntax?

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)))

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

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)))

View solution in original post

1 Reply
BrunPierre
Partner - Master
Partner - Master

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)))