Forum Discussion
Calculate percentage
Hi,
I am seeking help on below requirement and hoping you guys can guide me in right direction. I have a metric "actuals" and I wan to have a column where this metric will gets multiply by certain percentages, 0,10, 20 ... 100%
So my end visual should look like this if actuals value is 10
| 0% | 10% | 20% | 30% | 40% | 50% | 60% | 70% | 80% | 90% | 100% | |
| actuals | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
what should be the best approch to do this? is it possible to make this percentages dynamic for example if user chooses 5 then the increment in the percentages should be by 5 like 0%, 5%, 10%, 15% ... 95%, 100%
Thanks
Hi Anonymous,
Current the table and fields not able dynamic changes by filter because they do not work on the same level. For this scenario, you can create a table with detail granularity level of values to use on the column of matrix.
After these steps, you can write a measure formula to calculate and look up value from the raw table records and skip the calculation(if statement with MOD function and current selection value) on not match ranges to achieve dynamic column category.If you are confused about coding formula, please share some dummy some dummy data that keep the raw data structure for test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
1 Reply
Hi Anonymous,
Current the table and fields not able dynamic changes by filter because they do not work on the same level. For this scenario, you can create a table with detail granularity level of values to use on the column of matrix.
After these steps, you can write a measure formula to calculate and look up value from the raw table records and skip the calculation(if statement with MOD function and current selection value) on not match ranges to achieve dynamic column category.If you are confused about coding formula, please share some dummy some dummy data that keep the raw data structure for test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng