https://community.qlik.com/t5/QlikView/Conditional-IF-Statement/m-p/1883450#M1216941 <P>I am attempting to calculate the Sum of a group of receipts for multiple markets. However there are 2 markets in which I need the Sum cut in half.</P> <P>I have tried several nested IF statements so that those 2 are always cut in half, and the sum of all are brought in but have yet to figure it out.</P> <P>Any ideas?</P> Thu, 20 Jan 2022 15:41:14 GMT bwillis0802 2022-01-20T15:41:14Z https://community.qlik.com/t5/QlikView/Conditional-IF-Statement/m-p/1883450#M1216941 <P>I am attempting to calculate the Sum of a group of receipts for multiple markets. However there are 2 markets in which I need the Sum cut in half.</P> <P>I have tried several nested IF statements so that those 2 are always cut in half, and the sum of all are brought in but have yet to figure it out.</P> <P>Any ideas?</P> Thu, 20 Jan 2022 15:41:14 GMT https://community.qlik.com/t5/QlikView/Conditional-IF-Statement/m-p/1883450#M1216941 bwillis0802 2022-01-20T15:41:14Z https://community.qlik.com/t5/QlikView/Conditional-IF-Statement/m-p/1883609#M1216952 <P><FONT face="courier new,courier">Sum(If(Match(Market, 'MarketA', 'MarketB') Receipts/2, Receipts))</FONT></P> <P>-Rob<BR /><A href="http://www.easyqlik.com" target="_blank">http://www.easyqlik.com</A><BR /><A href="http://masterssummit.com" target="_blank">http://masterssummit.com</A><BR /><A href="http://qlikviewcookbook.com" target="_blank">http://qlikviewcookbook.com</A></P> Fri, 21 Jan 2022 02:39:41 GMT https://community.qlik.com/t5/QlikView/Conditional-IF-Statement/m-p/1883609#M1216952 rwunderlich 2022-01-21T02:39:41Z