This results in a value of 9.12 minutes to load per pallet for a picked order.
For nonpick orders the math is the same, but the value of the PickFlag is changed to 0. The result is a value of 6.36 minutes per pallet to load non-picked orders.
The result of dividing vMinToLoadPerPallet_Avg_Pick / vMinToLoadPerPallet_Avg_NonPick should be the result of dividing 9.12 by 6.36 which would equal 1.43. However, I'm getting a result of 9.12. I've tried putting parentheses around each variable, but then I get a result of Null ("-"). I've tried with and without $ and parens like this:
Re: Division of variables returns the value of the numerator
I added the = sign to both pick and nonpick formulas and I'm now getting the ratio result, which is a step forward. Unfortunately, my calcs are now showing the same result for all years and all warehouses. If you can take a look at the pivot table "Average Time to Load Per Pallet" on the sheet "Load Time factors - Pick vs Non-Pick" perhaps you can see what I mean.