I am trying to calculate gross profit margins and ROI. How do I get my formula result to appear as a percentage and not a 0.273492 number?
Hi,
If you left click on summary of the group you get a popup where you select the way you would like to view the column, see screenshot below.
This only works for parent items. If you want to have this for subitems you will have to use the CONCATENATE function.
Hope this helps
2 Likes
Thank you for your response.
I have tried that but it does not give the result of my formula as a percentage. Instead, it gives me the decimal number and adds the percentage to it at the end. Please see attached picture
So I would to see 64% as opposed to 0.64%
Hi,
Can you please share the formula you are using?
I think if you add “Multiply by 100” to your formula that would solve it.
1 Like
Hi Joseph
You are absolutely right. I multiplied by 100 and it gave me exactly what I needed. Thank you so much.
Kind regards
1 Like