Multi Row Formula to calculate a percentage

[BrandonS4]

I am stuck trying to calculate a formula on multiple rows.  I have the below data that I need to calculate:

Month                            Jan-20
A/R Beg Bal:                827,098,569
Net Sales:                    92,220,046
A/R ending balance:    809,984,903
A/R ending current      484,694,210

I want to have a formula as follows:

Beg A/R + Monthly Sales minus End A/R

divided by

Beg A/R + Monthly Sales minus End Current A/R

I would like to show this as a percentage.  Any suggestions????

Thanks!

[messi007 · Accepted solution]

@BrandonS4,

Please see below how you can do it.

I added Feb-20 in order to test:

If this solve the issue please mark as solved, it will help others,

Attached the workflow,

Regards,