1 Reply Latest reply on Jul 5, 2015 9:19 AM by Alexander Mou

    Creating Bins using Percentiles

    Manas Ranjan Kar

      I want to create labels for Sales, depending upon the percentiles they fall into. I am using the formula

       

      IF ZN([Sales]) <= ZN(PERCENTILE([Sales],0.10))

      THEN "0-10 PERCENTILE"

      END

       

      I am getting an error "Cannot mix aggregate and Non-Aggregate functions".  I don't want to go back to my data to create additional columns. Any suggestions?