For example, you can use the custom commission report with multiple criteria.

1. Open the custom commission report with multiple criteria, or click Calculations, and paste the calculation formula you previously created.
2. Click Add Table Calculation to open a second calculation editor.

3. In Calculation 2, paste the calculation formula. This is because the text labels should follow the same rules as the numeric calculation.

   

4. Next, you have to change the arguments. For example, if an employee's sales are less than $5,000, the label should be No Commission. To do this, between quotation marks, enter No Commission as the label.

   Optionally, you could include more detail in the label, for example: less than $5,000, no commission.

   

5. The second label is for sales below $10,000, but not below $5,000.

   

6. Lastly add the multiplication percentage of commissions as labels, for example, *0.02 would become 2% commission.

   

7. Click Save Table Calculations, and your columns will display with the labels.

   

8. Optionally, if you want to change the order of the calculation columns, you can drag and reorder the columns.