11 Replies Latest reply: Sep 19, 2017 10:46 AM by Mike Grattan RSS

    Division of variables returns the value of the numerator

    Mike Grattan

      I am trying to divide picked orders load time per pallet by non-picked orders load time per pallet to get a ratio.


      First variable vTimeToLoad_Avg_Pick:  Avg({<PickFlag={1}>} MinutesToLoad)

      Second variable vPalletsPerOrder_Pick:  Avg(Aggr(Avg({<PickFlag={1}>} DailyPallets), SalesOrder))

      Resulting variable calc vMinToLoadPerPallet_Avg_Pick:  $(vTimeToLoad_Avg_Pick) / $(vPalletsPerOrder_Pick)


      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:

      $(vMinToLoadPerPallet_Avg_Pick) / $(vMinToLoadPerPallet_Avg_NonPick)

      and I get null result for that as well.

      I also tried using the Div function and also got similar results.

      Anything else I can try?