10 Replies Latest reply on Oct 5, 2018 6:18 PM by Hari Ankem

    Estimate Calculation

    Vandana Samtani

      Hi All,

       

      I need help in a calculation based on the logic below -

      Calculation 1

      Sum all Shipments when Code = 4,

      Divide that value by all Shipments when code = both 4 & 5.

      If this number is below 0.75, than make it equal 0.75.

       

      Calculation 2

      Example:

      If total POS Units = 1000,000 Units

      Net Ships with Code = 4: 800,000 Units

      Net Ships with Code = 5: 200,000 Units

       

      Net Ship Share = 800,000/(800,000+200,000)= 0.8

       

      Estimated POS =  1,000,000/.80  = 125,000

       

      Any suggestions would be helpful.

       

      Thanks,

      Vandana