Based on the example table below:
I am getting the values in 'Column_2' by using PU_COUNT
How would I go by converting each value in 'Column_2' to a percentage amount?
Solved
How can I convert values received from PU_COUNT to percentages?
+7Best answer by joos.buijs
Hi @mohamed.ruzli.moham ,
When editing the KPI in the top you have formatting options (should show 'unformatted' or similar currently). Setting this to 'percentage' will add a percentage sign.
Please let me know if this helped! (and mark my post as an answer if it did :D)
+2Hi @mohamed.ruzli.moham ,
When editing the KPI in the top you have formatting options (should show 'unformatted' or similar currently). Setting this to 'percentage' will add a percentage sign.
Please let me know if this helped! (and mark my post as an answer if it did :D)
+7Hi @mohamed.ruzli.moham ,
When editing the KPI in the top you have formatting options (should show 'unformatted' or similar currently). Setting this to 'percentage' will add a percentage sign.
Please let me know if this helped! (and mark my post as an answer if it did :D)
Thanks :)
Hi, Mohamed,
Are you sure is PU_COUNT, and not PU_SUM? PU_COUNT returns the number of entries for each fruit, while PU_SUM returns the sum of the quantities (which I believe is what you're looking for...).
KPI = PU_SUM(...)/GLOBAL(SUM("Your_Table"."Your_Column"))
This will give you the percentage of each fruit in the total.
Hope this helps! ;)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.