3 Replies Latest reply on Sep 7, 2016 9:01 AM by David Li

    how to count how many records have values above average?

    Jesse yung

      Hi, i used this to distinguish which values are above or below average,

      avg([value])>total(avg([value]))

       

      but suppose I want to count how many are they, do i need to use a LOD 'fixed' function?

       

      thanks!