Calculated field for Total% & Cumulative% with total column

Question & Answer
,
1

Hi,
I want to create a calculated fields for the total% and cumulative% using the total column for all the products.
Example,
|Product|Total|Total%|Cumulative%|
|A|23|29.87012987|29.87012987|
|B|34|44.15584416|74.02597403|
|C|16|20.77922078|94.80519481|
|D|4|5.194805195|100|

Could someone help me with the formula to have the fields created as shown in the example with the percentage precision to 2 digits.

2

Here is the function you can use to calculate the percent of the total

Also, take a look at the blog below for performing cumulative functions.

Hope this helps. if you looking for something different. let us know.

1 Like
3

Hi [sakkamzn],
Thank you for your response. But, I might have missed to explain that the total is not a direct numeric field. Total is a distinct count of a string. So iā€™m unable to use percentofTotal & comparative calculations.

4

Hi @Sri

What is your dataset? Is it possible for you to handle this at the dataset level?