3 Replies Latest reply on Dec 20, 2013 7:46 AM by Dana Withers

    Can't compare percentile and measure value

    Manas Ranjan Kar

      Here is my formula

       

      IIF([ Revenue ]>[Revenue_95pc],[Revenue_95pc],[Revenue])

       

      [Revenue] is the revenue

      [Revenue_95pc] is the 95th percentile

       

       

      I get the error "Cannot mix aggregate and non-aggregate arguments to function"

       

      My aim is to compare a row and replace the revenue value with the 95th percentile value, if it is greater than the 95th percentile. The motive is to fit my data and avoid outliers.