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

    LOD Calculation giving and unexpected result

    John Burton



      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:




      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:



      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