5 Replies Latest reply on Sep 12, 2019 6:57 AM by Jim Dehner

    Division & LOD Calculation Problem

    Christine Wang

      Hello,

      I am struggling with some division operation and LOD calculation problems here (workbook attached). What I am trying to achieve are

      1. calculate an average margin (sales per unit quantity) for each given product in all 3 regions (R1, R2, & R3; excluding zeros and nulls), and
      2. calculate a value for each given product by multiplying the above margin average with the quantities in 2 regions only.

       

      My first problem was that when I tried to calculate the average, the division operation did not seem to work (supposedly due to an aggregation versus non-aggregation issue?)

      My calculated field for the average margin ([Average margin/kg]) is as follows:

      Screen Shot 2019-09-11 at 21.27.46.png

       

      My second struggle was that when I tried to sum up the quantities in 2 select regions, the values did not seem to add up correctly,

      Screen Shot 2019-09-11 at 21.19.36.png

       

      and that the simple multiplication did not look right, either:

      Screen Shot 2019-09-11 at 21.28.37.png

       

      Your comments or suggestions are much appreciated. Thank you in advance for your time and help.

       

      Best regards,

      Christine