topic Calculating Amount which are 30 days overdue in App Development https://community.qlik.com/t5/App-Development/Calculating-Amount-which-are-30-days-overdue/m-p/1216873#M23537 <HTML><HEAD></HEAD><BODY><P>I'm trying to make the sum of amounts openstanding (AR) which are more than 30 days overdue.</P><P></P><P>I have the following formula , where Vervaldag = Due Date and BedragOpenstaand=Openstanding Amount</P><P></P><P>=Sum({&lt;FactTypeId={5}, "&gt;=$((date(today())-Vervaldag)&gt;30) &gt;}[_BedragOpenstaand])</P><P></P><P>Can any help.</P><P></P><P>Thx.</P></BODY></HTML> Thu, 02 Mar 2017 12:14:57 GMT 2017-03-02T12:14:57Z Calculating Amount which are 30 days overdue https://community.qlik.com/t5/App-Development/Calculating-Amount-which-are-30-days-overdue/m-p/1216873#M23537 <HTML><HEAD></HEAD><BODY><P>I'm trying to make the sum of amounts openstanding (AR) which are more than 30 days overdue.</P><P></P><P>I have the following formula , where Vervaldag = Due Date and BedragOpenstaand=Openstanding Amount</P><P></P><P>=Sum({&lt;FactTypeId={5}, "&gt;=$((date(today())-Vervaldag)&gt;30) &gt;}[_BedragOpenstaand])</P><P></P><P>Can any help.</P><P></P><P>Thx.</P></BODY></HTML> Thu, 02 Mar 2017 12:14:57 GMT https://community.qlik.com/t5/App-Development/Calculating-Amount-which-are-30-days-overdue/m-p/1216873#M23537 2017-03-02T12:14:57Z Re: Calculating Amount which are 30 days overdue https://community.qlik.com/t5/App-Development/Calculating-Amount-which-are-30-days-overdue/m-p/1216874#M23538 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Sum({&lt;FactTypeId={5}, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Vervaldag</SPAN> = {"=Date - <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Vervaldag</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> &gt; 30</SPAN>"} &gt;} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> </SPAN>[_BedragOpenstaand])</STRONG></SPAN></P></BODY></HTML> Thu, 02 Mar 2017 16:27:11 GMT https://community.qlik.com/t5/App-Development/Calculating-Amount-which-are-30-days-overdue/m-p/1216874#M23538 sunny_talwar 2017-03-02T16:27:11Z