Percentage Totals Formula

[BrandonS4]

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%

[fmvizcaino]

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

[ImadZidan · Accepted solution]

Hello,

another way besides @fmvizcaino  great solution.

Just an idea.

Hope it helps.

[fmvizcaino]

Ouch @ImadZidan ! So much easier than mine! hahahaha

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

[grazitti_sapna]

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

I hope this helps.

Thanks.

[ImadZidan]

trying to progress and catch up  hhhhhhhhhh.

Thanks for the encouragement.

[BrandonS4]

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!