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

@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,

Calc_20210319.yxmd