
Re: Division of variables returns the value of the numerator
Aar Kay Sep 18, 2017 2:00 PM (in response to Mike Grattan)Could you be able to share the app ??

Re: Division of variables returns the value of the numerator
Mike Grattan Sep 18, 2017 2:20 PM (in response to Aar Kay)I have attached a copy of the app. Please feel free to take a look. Thank you.

Re: Division of variables returns the value of the numerator
Aar Kay Sep 18, 2017 3:08 PM (in response to Mike Grattan)Add '=' sign to the variable exp
vMinToLoadPerPallet_Avg_Pick: =$(vTimeToLoad_Avg_Pick) / $(vPalletsPerOrder_Pick)
vMinToLoadPerPallet_Avg_NonPick: =$(vTimeToLoad_Avg_NonPick) / $(vPalletsPerOrder_NonPick)
and Use this exp vMinToLoadPerPallet_Avg_Pick / vMinToLoadPerPallet_Avg_NonPick

Re: Division of variables returns the value of the numerator
Mike Grattan Sep 18, 2017 3:34 PM (in response to Aar Kay)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 NonPick" perhaps you can see what I mean.
Thank you for your assistance.

Re: Division of variables returns the value of the numerator
Aar Kay Sep 18, 2017 3:51 PM (in response to Mike Grattan)Seems to be working for me
PFA with new sheet

Re: Division of variables returns the value of the numerator
Mike Grattan Sep 18, 2017 4:40 PM (in response to Aar Kay)Using a pivot table I am seeing the numbers duplicate for all years and all warehouses.


Re: Division of variables returns the value of the numerator
Aar Kay Sep 18, 2017 5:25 PM (in response to Mike Grattan)Sorry
Remove the '=' sign for variables
and try using this exp
$(=$(vMinToLoadPerPallet_Avg_Pick))
/
$(=$(vMinToLoadPerPallet_Avg_NonPick))

Re: Division of variables returns the value of the numerator
Mike Grattan Sep 18, 2017 5:34 PM (in response to Aar Kay) 
Re: Division of variables returns the value of the numerator
Mike Grattan Sep 19, 2017 10:00 AM (in response to Aar Kay)I've tried various combinations of using the = sign for formulas/variables and still coming up with strange results. Any other ideas?

Re: Division of variables returns the value of the numerator
Aar Kay Sep 19, 2017 10:43 AM (in response to Mike Grattan)you can use Column(1)/Column(2) for ratio

Re: Division of variables returns the value of the numerator
Mike Grattan Sep 19, 2017 10:46 AM (in response to Aar Kay)Ok, that is a method of which I was not aware...and it works great. Thanks!






