topic Re: DSO calulation in QlikView https://community.qlik.com/t5/QlikView/DSO-calulation/m-p/870518#M1010542 <HTML><HEAD></HEAD><BODY><P>these may help you :</P><P><A href="https://community.qlik.com/qlik-blogpost/2787">Accumulative Sums</A></P><P></P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Mon, 04 May 2015 13:25:16 GMT giakoum 2015-05-04T13:25:16Z DSO calulation https://community.qlik.com/t5/QlikView/DSO-calulation/m-p/870517#M1010541 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>please help me out to find out DSO..</P><P>my DSO calculation is like below</P><P></P><P>Say i m in Apr 15 than For Apr DSO calculation is [Net Outstanding/ (jan Amount+Feb AMount + March Amount)/3) *30]</P><P>for Mar 15, DSO calculation will be <SPAN style="font-size: 13.3333330154419px;"> [Net Outstanding/ (DecAmount 14+JanAMount&nbsp; 15+ FebAmount 15)/3) *30]</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">and for Feb, DSO would be <SPAN style="font-size: 13.3333330154419px;"> [Net Outstanding/ (Nov Amount 14+Dec AMount 14 + JanAmount 15)/3) *30].</SPAN></SPAN></P><P></P><P></P><P>Now i want to show Trend for these three Month.</P><P></P><P>Kindly help</P><P></P><P>thanks </P></BODY></HTML> Mon, 04 May 2015 13:22:26 GMT https://community.qlik.com/t5/QlikView/DSO-calulation/m-p/870517#M1010541 abhaysingh 2015-05-04T13:22:26Z Re: DSO calulation https://community.qlik.com/t5/QlikView/DSO-calulation/m-p/870518#M1010542 <HTML><HEAD></HEAD><BODY><P>these may help you :</P><P><A href="https://community.qlik.com/qlik-blogpost/2787">Accumulative Sums</A></P><P></P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Mon, 04 May 2015 13:25:16 GMT https://community.qlik.com/t5/QlikView/DSO-calulation/m-p/870518#M1010542 giakoum 2015-05-04T13:25:16Z