Forum Discussion
Solved
Calculate Sum Issue per row
I have multiple rows with the same order number but different products ship at different times. How do I get the total sale amount to be on the each row of the same order number? My goal is to have the $16 show on each row.
Order Date Amount Total
1 1/1 $5 $16
1 1/3 $7 $16
1 1/5 $4 $16
Try the following:
Total = CALCULATE(SUM([Amount]), ALLEXCEPT(Table, [Order]))
2 Replies
Try the following:
Total = CALCULATE(SUM([Amount]), ALLEXCEPT(Table, [Order]))PERFECT!!!!! vicky_ Thank you! The ALLEXCEPT was what I was missing!