Formula results as a percentage

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?


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


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
Screenshot 2023-05-22 at 11.37.07

So I would to see 64% as opposed to 0.64%


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