You can use simple number functions to perform useful percent calculations. Simple number functions include addition, subtraction, multiplication, and division.
Function | Description | Examples |
---|---|---|
* | Returns the result of multiplying both numbers. |
|
+ | Returns the result of adding both numbers. |
|
- | Returns the result of subtracting the second number from the first. |
|
/ | Returns the result of dividing the first number by the second. |
|
Calculate percentages
Calculating percentages is useful when you want to see, for example, the percentage revenue generated from each channel (online, stores, partner, etc.). For example, you can figure out the percentage revenue generated from each channel (online, stores, partners, etc.).
Create a formula called Percent Revenue
in the Formula Assistant:
( sum ( revenue ) / group sum ( revenue ) ) \* 100
Now you can search by each channel, using the percent revenue formula that you just created.