Hello
I am currently working on an accounts receivable dashboard. I am trying to calculate the Accounts Receivable Turn Over ratio which is
Revenue / ((Beg Bal. A/R + Ending Bal A/R) / 2)
So far to get ending balance I have this expression. Num(Sum({1}Balance),'$#,##0.##')
I imported the values for Total Revenue as "A" and Beginning Balance as "B".
I tried this but it didn't work.
(Sum(A)) / (((B) + (Num(Sum({1}Balance),'$#,##0.##'))