1 Reply Latest reply on Feb 21, 2018 5:29 PM by Chris McClellan

    LOD calculation not working as expected

    Kevin Clark

      Example.png

       

       

      Hello

       

      I'm using the following formula to try to calculate the number of times a report ID repeats in the data. For some reason, my formula is not working properly. See below:

       

      { FIXED  [Report ID]: SUM([Number of Records]) }

       

      The first report ID "1010" sums 2, which is correct, however, the second report ID "1111" should count only 3.

       

      Thanks!