topic Conditional Sum in QlikView https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/599059#M478305 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can somebody assist me with the correct syntax for the following expression, I have an error in the expression:</P><P></P><P>If(Sum(([Bales Loaded])-Sum([Bales Delivered]))&lt;=0,0,Sum([Bales Loaded])-Sum([Bales Delivered]))</P><P></P><P>Thank you</P></BODY></HTML> Thu, 20 Mar 2014 08:35:03 GMT 2014-03-20T08:35:03Z Conditional Sum https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/599059#M478305 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can somebody assist me with the correct syntax for the following expression, I have an error in the expression:</P><P></P><P>If(Sum(([Bales Loaded])-Sum([Bales Delivered]))&lt;=0,0,Sum([Bales Loaded])-Sum([Bales Delivered]))</P><P></P><P>Thank you</P></BODY></HTML> Thu, 20 Mar 2014 08:35:03 GMT https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/599059#M478305 2014-03-20T08:35:03Z Re: Conditional Sum https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/599060#M478306 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use this,</P><P></P><P>If((Sum([Bales Loaded])-Sum([Bales Delivered]))&lt;=0,0,(Sum([Bales Loaded])-Sum([Bales Delivered])))</P><P></P><P>regards,</P></BODY></HTML> Thu, 20 Mar 2014 08:40:29 GMT https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/599060#M478306 PrashantSangle 2014-03-20T08:40:29Z Re: Conditional Sum https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/599061#M478307 <HTML><HEAD></HEAD><BODY><P>Thank you, works perfectly</P></BODY></HTML> Thu, 20 Mar 2014 08:50:32 GMT https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/599061#M478307 2014-03-20T08:50:32Z