I have a simple requirement of calculating percentage of value from one column as compared to other dynamically when creating a new table/elastic cube object. I tried to use Div function but it returns only integer value e.g. 1/2 returns 0 whereas it should return 0.5.
Now I know that I can multiply denominator with 100 and then divide result by 100 again but then I will loose precision of 2 decimal points. e.g. I would like to show result of 10/3 = 33.33 but dividing 3333 by 100 results in 33.
If we can get a version of current Div function where we can specify decimal point precision that would solve an issue. Another function that would of great help is Percentage where we can find percentage of one number as compared to other e.g. Percent(3,10) = 33.33
Right now I am looking for workaround to calculate this value for one of the column. I can't use percentage formatting in widget as I am using Pivot and columns to show columns with dynamics header text. Thank you!
Please sign in to leave a comment.