Forum Discussion
Kimbornhoft
9 years agoHelper I
Incorrect calculated measure total
Hi, I have a new measure Total Shipped Value = (sum(REV_HistoryReport[Total Li Valu Amt]) /sum(REV_HistoryReport[Ord Bill Unit Qty]) * sum(OpenOrders[Qty Filled])) which works correctly ...
Anonymous
9 years agoNot applicable
Ya, that won't math correctly. If math was a verb.
1 2
2 3
3 4
(1+2+3) * (2 + 3 + 4) = 6 * 9 = 54.
(1*2) + (2*3) + (3*4) = 2 + 6 + 12 = 20.
You want the latter, but are doing the fomer.
I would think...
Total Shipped Value = sumx(REV_HistoryReport, REV_HistoryReport[Total Li Valu Amt]) / REV_HistoryReport[Ord Bill Unit Qty] * OpenOrders[Qty Filled])
But... I'm skeptical that is going to handle OpenOrders correctly. How are those tables related?
Kimbornhoft
9 years agoHelper I
Here are the relationships