Forum Discussion

zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
6 years ago
Solved

Complex round up sumx issue

Hi folks, I am facing a problem that I have spent hours on and still can't crack it.  Here is my situation: I am selling various products (A,B,...), each of kind of product is stored in my wareho...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
6 years ago
Anonymous 

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...

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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