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

    Division & LOD Calculation Problem

    Christine Wang


      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,