tlh
New member
- Joined
- Nov 15, 2019
- Messages
- 6
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
I'm attempting to report a MTD value (BTZ Feed Ozs MTD). The daily value (BTZ Feed Ozs) is calculated by multiplying a row value (BTZ Tons) by a measure (BTZ 30day avg).
The result I'm looking for is the additive value of each day's calculated value, so for example on 3/2 the individual values for 3/1 and 3/2 are 312 & 271 which would be 583 (312+271).
The MTD value (BTZ Feed Ozs MTD) that is returned on 3/2 is 591 which is the sum of the daily values (BTZ Feed Ozs 692+587=1297) multiplied by the 3/2 value of the BTZ 30day avg measure (0.46), (692+587)*(0.46208)=591.
I've tried different approaches, but can't seem to get the result I require. The grand total below is for illustrative purposes only, I don't need that value as I'm graphing the MTD values throughout the month.
Thanks,
Troy
https://www.dropbox.com/scl/fi/ewic...ion.xlsx?dl=0&rlkey=sk6zihig94jerr9q9myo4ilz9
The result I'm looking for is the additive value of each day's calculated value, so for example on 3/2 the individual values for 3/1 and 3/2 are 312 & 271 which would be 583 (312+271).
The MTD value (BTZ Feed Ozs MTD) that is returned on 3/2 is 591 which is the sum of the daily values (BTZ Feed Ozs 692+587=1297) multiplied by the 3/2 value of the BTZ 30day avg measure (0.46), (692+587)*(0.46208)=591.
I've tried different approaches, but can't seem to get the result I require. The grand total below is for illustrative purposes only, I don't need that value as I'm graphing the MTD values throughout the month.
Thanks,
Troy
https://www.dropbox.com/scl/fi/ewic...ion.xlsx?dl=0&rlkey=sk6zihig94jerr9q9myo4ilz9