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

    LOD calculation not working as expected

    Kevin Clark






      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.