Percentage Totals Formula

I am trying to add the percentage totals below each of the following columns as shown below. How do I achieve this?

Total	Current	1- 30	31- 60	61- 90	91-120	121-150	151-180	181-364	Over364
2,075,709.00	1,655,851.00	135,853.00	155,875.00	128,130.00	0.00	0.00	0.00	0.00	0.00
	80%	7%	8%	6%	0%	0%	0%	0%	0%	100%

Expression

Accepted answers

Hello,

another way besides @fmvizcaino great solution.

Just an idea.

Hope it helps.

Percentage.yxzp

All comments

Hi @BrandonS4 ,

Please find attached an example showing how to accomplish this. Keep in mind that the workflow only works for 1 row only.

Best,

Fernando Vizcaino

2020-08-11 Percentage Totals Formula.yxmd

Hello,

another way besides @fmvizcaino great solution.

Just an idea.

Hope it helps.

Percentage.yxzp

Ouch @ImadZidan ! So much easier than mine! hahahaha

@BrandonS4 , pretend that my answer does'nt exist please 😉

Hi @BrandonS4 , you can give this a try as well in case your fields are dynamic.

I hope this helps.

Thanks.

percentagetotal.yxmd

Thank you for the help! Since I have repeat this for everyone on my team, I will turn this into a macro and it should work great!

Quick Links

Tags

This months top contributors