4 Replies Latest reply on Aug 26, 2016 10:33 AM by John Burton

    LOD Calculation giving and unexpected result

    John Burton

      Hi,

       

      I'm using a LOD calculation to test which of two numbers is greater but in some cases I'm getting an incorrect result.

       

      Here is the LOD calculation:

       

      count.PNG

       

      I'm comparing the amount in a base year to the amount in a comparison year.  I want to get a total count across all municipalities of cases where the number is higher in the comparison year.  I know the total count should be 186 but this is not the result I'm getting.

       

      Here is an example of an incorrect result:

       

      table.PNG

      The amount has decreased between years but the calculation indicates and increase.

       

      If you know what I'm doing wrong could you please let me know

       

      Here are the other calculations used in the above table:

       

      base year calc.PNG

      comparison year calc.PNG