Hoping someone can help. I cannot add the QV file due to data protection, but i have exported the issues to excel and attached. See references for details.
I need to work out how many pallets we have in stock - to do this I am dividing total stock by 880. I need to round UP to the nearest pallet. Using a ceiling in the expression (pivot table) didn't work so I have added it into my LOAD script.
quantity, ceil((quantity/880),1.0) AS ceilquantity
This gave me excel file v3 attached. Column F is what the ceiling is giving me. Column I is what it SHOULD be giving me. If I use row 7 as an example, 63880/880 = 72.59 so why is it rounding to 74, rather than 73?
I found another post on here that used a floor instead so I changed my LOAD script to this.
quantity, floor((quantity/880)+0.50,1.0) AS floorquantity
This gave me excel file v4 attached. Column F and I are as above - but as you can see this gives different answers.