2 Replies Latest reply on Dec 8, 2017 7:26 AM by Tony Fahd

    how to use aggregate and non aggregate fields in a if statement?

    Tony Fahd

      Hi I am attaching a workbook where i have a test field, customers and category. each customer falls under a category (1,2 or 3).

      I created an if function (calculation1) that says : if the category is 1  then countD customers /13. but i have an error when it says i can't mix aggregate and non aggregate functions

       

      any solution?