Hello my name is Leonardo , and i have problem with this table.
It has repetitive values and i want to calculate some measures
[IMG]http://i66.tinypic.com/29qfl88.png[/IMG]
The table shows the volume in "M3" for each SKU produced, as well as the Volume of "Lubrication Consumption (M3)" and "Washing Machine Consumption (M3)", which are the same for each "LINE". The general consumption of water on the "Consumption M3" day is also shown. What I want to calculate: "Other Consumption (m3)" = "Consumption M3" - "Consumption Lubrication (m3)" - "Washing Machine Consumption (m3)"; for each day. for example: For 03/01/2018 would have Other consumptions (m3) = 686 - (41 + 21 + 40 + 0) - (135 + 100 + 0 + 154). Likewise I want to calculate the WUR (Water Usage Ratio) = ((Sum of "M3") + (Sum "of Consumption M3")) / (Sum of "M3"), for each day. For example: For 03/01/2018 I would have WUR VDR = ((28 + 107 + 68 + ....) + 686) / (28 + 107 + 68 + ..)
Please help me, I've broken my head trying to calculate it with distinct but it still does not work out. My entire thanks. Leonardo LIMA PERU
