topic Re: calculated measure in App Development https://community.qlik.com/t5/App-Development/calculated-measure/m-p/1650461#M48534 <P>thanks for replying but your expression doesn't give a transaction total if there is a particular discount used in the transaction.</P> Sun, 24 Nov 2019 17:28:06 GMT johndoub 2019-11-24T17:28:06Z calculated measure https://community.qlik.com/t5/App-Development/calculated-measure/m-p/1650457#M48531 <P>I’m trying to &nbsp;create a measure that would give me the total transaction net amt if the transaction consists of a particular discount reason.</P><P>For example, in transaction 52609 one of items used the discount reason “Mailer-F1:20”.&nbsp; The total net amt for this transaction is 624.20.</P><P>Could you tell me what expression for the measure should be to give this result?</P><TABLE><TBODY><TR><TD>Date/Time</TD><TD>Store</TD><TD>Tran</TD><TD>Item code</TD><TD>Qty</TD><TD>Unit price</TD><TD>Reason</TD><TD>Disc $</TD><TD>Net Amt</TD></TR><TR><TD>09/01/2019 12:54:05 PM</TD><TD>107</TD><TD>52606</TD><TD>1919 FOX</TD><TD>1</TD><TD>64.99</TD><TD>50 Off Extra Sale</TD><TD>32.49</TD><TD>32.50</TD></TR><TR><TD>09/01/2019 12:57:56 PM</TD><TD>107</TD><TD>52607</TD><TD>1862 RBK</TD><TD>1</TD><TD>14.50</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>14.50</TD></TR><TR><TD>09/01/2019 12:57:56 PM</TD><TD>107</TD><TD>52607</TD><TD>3461 LEE</TD><TD>1</TD><TD>14.50</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>14.50</TD></TR><TR><TD>09/01/2019 12:57:56 PM</TD><TD>107</TD><TD>52607</TD><TD>3830 PAS</TD><TD>1</TD><TD>24.50</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>24.50</TD></TR><TR><TD>09/01/2019 01:10:40 PM</TD><TD>107</TD><TD>52608</TD><TD>1937 IBK</TD><TD>1</TD><TD>98.50</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>98.50</TD></TR><TR><TD>09/01/2019 01:21:14 PM</TD><TD>107</TD><TD>52609</TD><TD>1102 LEE</TD><TD>5</TD><TD>2.25</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>11.25</TD></TR><TR><TD>09/01/2019 01:21:14 PM</TD><TD>107</TD><TD>52609</TD><TD>1247 LEE</TD><TD>1</TD><TD>14.95</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>14.95</TD></TR><TR><TD>09/01/2019 01:21:14 PM</TD><TD>107</TD><TD>52609</TD><TD>1034 LEE</TD><TD>1</TD><TD>16.50</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>16.50</TD></TR><TR><TD>09/01/2019 01:21:14 PM</TD><TD>107</TD><TD>52609</TD><TD>1927 BRO</TD><TD>1</TD><TD>275.00</TD><TD>Mailer-F1:20</TD><TD>55.00</TD><TD>220.00</TD></TR><TR><TD>09/01/2019 01:21:14 PM</TD><TD>107</TD><TD>52609</TD><TD>2667 VLG</TD><TD>1</TD><TD>118.00</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>118.00</TD></TR><TR><TD>09/01/2019 01:21:14 PM</TD><TD>107</TD><TD>52609</TD><TD>1922 OST</TD><TD>1</TD><TD>145.00</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>145.00</TD></TR><TR><TD>09/01/2019 01:21:14 PM</TD><TD>107</TD><TD>52609</TD><TD>1989 IBK</TD><TD>1</TD><TD>98.50</TD><TD>&nbsp;</TD><TD>0.00</TD><TD>98.50</TD></TR></TBODY></TABLE><P>Thanks.</P><P>John Doub</P><P>&nbsp;</P> Sun, 24 Nov 2019 15:45:11 GMT https://community.qlik.com/t5/App-Development/calculated-measure/m-p/1650457#M48531 johndoub 2019-11-24T15:45:11Z Re: calculated measure https://community.qlik.com/t5/App-Development/calculated-measure/m-p/1650458#M48532 <P>Net Amt : <STRONG>Sum([Unit Price])-Sum([Disc $])</STRONG></P> Sun, 24 Nov 2019 16:11:10 GMT https://community.qlik.com/t5/App-Development/calculated-measure/m-p/1650458#M48532 Anil_Babu_Samineni 2019-11-24T16:11:10Z Re: calculated measure https://community.qlik.com/t5/App-Development/calculated-measure/m-p/1650461#M48534 <P>thanks for replying but your expression doesn't give a transaction total if there is a particular discount used in the transaction.</P> Sun, 24 Nov 2019 17:28:06 GMT https://community.qlik.com/t5/App-Development/calculated-measure/m-p/1650461#M48534 johndoub 2019-11-24T17:28:06Z