topic How to calculate A/R Turnover in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-A-R-Turnover/m-p/614792#M226828 <HTML><HEAD></HEAD><BODY><P><BR />Hello</P><P></P><P>I am currently working on an accounts receivable dashboard. I am trying to calculate the Accounts Receivable Turn Over ratio which is</P><P></P><P>Revenue / ((Beg Bal. A/R + Ending Bal A/R) / 2)</P><P></P><P>So far to get ending balance I have this expression. Num(Sum({1}Balance),'$#,##0.##')</P><P>I imported the values for Total Revenue as "A" and Beginning Balance as "B".</P><P></P><P>I tried this but it didn't work.</P><P></P><P>(Sum(A)) / (((B) + (Num(Sum({1}Balance),'$#,##0.##'))</P></BODY></HTML> Thu, 20 Feb 2014 20:48:24 GMT 2014-02-20T20:48:24Z How to calculate A/R Turnover https://community.qlik.com/t5/QlikView/How-to-calculate-A-R-Turnover/m-p/614792#M226828 <HTML><HEAD></HEAD><BODY><P><BR />Hello</P><P></P><P>I am currently working on an accounts receivable dashboard. I am trying to calculate the Accounts Receivable Turn Over ratio which is</P><P></P><P>Revenue / ((Beg Bal. A/R + Ending Bal A/R) / 2)</P><P></P><P>So far to get ending balance I have this expression. Num(Sum({1}Balance),'$#,##0.##')</P><P>I imported the values for Total Revenue as "A" and Beginning Balance as "B".</P><P></P><P>I tried this but it didn't work.</P><P></P><P>(Sum(A)) / (((B) + (Num(Sum({1}Balance),'$#,##0.##'))</P></BODY></HTML> Thu, 20 Feb 2014 20:48:24 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-A-R-Turnover/m-p/614792#M226828 2014-02-20T20:48:24Z