Category / Section
How to use Total Percentage Function within IF expressions?
Published:
How to use the Total Percentage Function within IF expressions
This article explains how to use the total percentage function within IF expressions in a proper way.
Note: Currently expression designer does not support the use of the Total Percentage function within IF expressions. However, there is a workaround for this limitation. You can calculate the Total Percentage separately and then use the result within the IF expression.
Steps to calculate the Total Percentage:
- Create a separate expression to calculate the Total Percentage and save the result of the Total Percentage calculation to a variable. For example, you can save it to a variable called “TotalPercentage”.
- Use the variable “TotalPercentage” within your IF expression. For example:
- The expected result will be shown below:
By following these steps, you can overcome the limitation of not being able to use the Total Percentage function directly within IF expressions in our expression designer.