7 Replies Latest reply on Apr 20, 2017 1:13 PM by Nathan Flanagan

    LOD with If statement

    Nathan Flanagan

      I have tried to create this LOD calculated field.

       

      IF  ISNULL([Clear Dt])

         THEN

         { FIXED   [ID]: AVG([Total Cost])}

      END

       

      I would assume this to take the average of each [ID] and then if I sum the dimension when I display the field, it should return 17 thousand and something. Instead, I see that it is summing each of the values of the [total cost] without first finding the average. I don't know why this doesn't work and would love any help or suggestions.

      Here is a packaged workbook as well. I hope it works, this is the first time posting a question.

       

      Thanks, Nathan Flanagan