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.