I’m trying to create a measure that would give me the total transaction net amt if the transaction consists of a particular discount reason.
For example, in transaction 52609 one of items used the discount reason “Mailer-F1:20”. The total net amt for this transaction is 624.20.
Could you tell me what expression for the measure should be to give this result?
| Date/Time | Store | Tran | Item code | Qty | Unit price | Reason | Disc $ | Net Amt |
| 09/01/2019 12:54:05 PM | 107 | 52606 | 1919 FOX | 1 | 64.99 | 50 Off Extra Sale | 32.49 | 32.50 |
| 09/01/2019 12:57:56 PM | 107 | 52607 | 1862 RBK | 1 | 14.50 | | 0.00 | 14.50 |
| 09/01/2019 12:57:56 PM | 107 | 52607 | 3461 LEE | 1 | 14.50 | | 0.00 | 14.50 |
| 09/01/2019 12:57:56 PM | 107 | 52607 | 3830 PAS | 1 | 24.50 | | 0.00 | 24.50 |
| 09/01/2019 01:10:40 PM | 107 | 52608 | 1937 IBK | 1 | 98.50 | | 0.00 | 98.50 |
| 09/01/2019 01:21:14 PM | 107 | 52609 | 1102 LEE | 5 | 2.25 | | 0.00 | 11.25 |
| 09/01/2019 01:21:14 PM | 107 | 52609 | 1247 LEE | 1 | 14.95 | | 0.00 | 14.95 |
| 09/01/2019 01:21:14 PM | 107 | 52609 | 1034 LEE | 1 | 16.50 | | 0.00 | 16.50 |
| 09/01/2019 01:21:14 PM | 107 | 52609 | 1927 BRO | 1 | 275.00 | Mailer-F1:20 | 55.00 | 220.00 |
| 09/01/2019 01:21:14 PM | 107 | 52609 | 2667 VLG | 1 | 118.00 | | 0.00 | 118.00 |
| 09/01/2019 01:21:14 PM | 107 | 52609 | 1922 OST | 1 | 145.00 | | 0.00 | 145.00 |
| 09/01/2019 01:21:14 PM | 107 | 52609 | 1989 IBK | 1 | 98.50 | | 0.00 | 98.50 |
Thanks.
John Doub
