Forum Discussion
Complex round up sumx issue
This one works the way you wanted... See the file attached. But don't ask me about the formula. It's a bit of math trickery.
Best
D
"f I sell on Monday 0,7 of A pallet, the number of vacant pallets is 0. Once I sell on Tuesday 0,5 pallet of A again, The number I am looking for will be 1 (1,2 rounded down to 1 and 0,2 is left for the following days [NOTE: .8 is left, not .2) and if I sold on Wednesday 0,9 pallet, then the number is 1"
I think the number is 2 (vacant pallets) and there is 0.9 left of the partial one for a future withdrawal. That's because what you are doing is you're trying to calculate the number of empty pallets within a period of time, not only on a single day, so you have to accumulate the amounts properly.
Best
D
my aim is to create a line chart, which will tell me, how many pallets have been emptied each day. For this reason I need highlighted information:
Monday - 0,7 pallet A sold= 0 pallet empty - 0,3 left on the first pallet
Tuesday - 0,5 pallet A sold = 1 pallet emptied - 0,8 left on the second pallet pallet
Wednesday - 0,9 pallet A sold = 1 pallet emptied - 0,9 left on the third pallet
However I am also intrested in total:Total emptied pallets: 2
I am afraid that your formulas doesn't work...This one works the way you wanted... See the file attached. But don't ask me about the formula. It's a bit of math trickery.
Best
D
