Percentage Functions in Query Designer
There are 5 percentage functions you can use in defining calculated key figures or formulas in the query:
Percentage Share (%A)
Generates the percentage share of Operand 1 and Operand 2. Put simply, OP1 %A OP2 = OP1 / OP2 * 100%. This function is also useful in order to quickly change any key figure or formula to use percentage format – by getting the percentage share of that number against 100.
Percentage Variance (%)
Gives the percentage variance between Operand 1 and Operand 2. OP1 % OP2 = (OP1 – OP2) / OP2 * 100%. If you need (OP2 – OP1)/OP2 * 100%, multiply the expression by -1, i.e. OP % OP2 * (-1).
Percentage Share of Result (%CT)
Gives the percentage share of the single value agains the subtotal defined in query. For example, %CT Sales (assuming the query have store and month data) will provide percentage of sales vs the total at store/month level, not the overall total at month.
Percentage Share of Overall Result (%GT)
Generates the percentage share of the overall results. If the query has a filter, this percentage ignores that filter. For example, %GT Sales (in the same scenario above) will give the percentage against the overall result regardless of the current filter.
Percentage Share of Report Result (%RT)
Generates the percentage share of the query results. It is similar to %GT except that if the query has a filter, it will be applied before this percentage calculation.
