Comments
-
Could you do a call with me to look at this? If you have my work email we can jump on a quick call.
-
Hi Jae, yes I separated out the numerator and denominator to troubleshoot. If I write your statement I am not getting the correct results, rather I get the denominator value before applying a filter.
-
I have tried expanding the decimals yes, I tested it the denominator is stuck at 329. Thanks.
-
It is a beastmode and it is blue. It seems to happen only when the number after the decimal place is 0. Another example is 24.03%. If I use round(24.03%,1) to get 1 decimal place it rounds it to be 24% not 24.0%.
-
Hi, the it is a calculated field with a numerator and a denominator to give me the percentage so it should show as 10.0%. I cannot use the built in formatting options in this case because I am concatenating it with text and using it as a summary number beastmode. I am using it as the summary number in a bar chart.
-
Hi Grant, I am using the function as you describe above(Round(Percentage,1), however it is rounding 10.0% to display as 10%. I would like a way to display it as 10.0% percent also, the FLOOR method you describe does not seem like it would allow it to display as 10.0% either? Correct me if I am wrong. Thanks
