topic Re: calcul rate using the last day in Management & Governance https://community.qlik.com/t5/Management-Governance/calcul-rate-using-the-last-day/m-p/1357086#M10217 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14938112253499337 jive_text_macro" jivemacro_uid="_14938112253499337"> <P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(value)/</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Day(MonthEnd(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Date</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">))</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> AS Rate</SPAN></P> </PRE><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Wed, 03 May 2017 11:33:53 GMT rahulpawarb 2017-05-03T11:33:53Z calcul rate using the last day https://community.qlik.com/t5/Management-Governance/calcul-rate-using-the-last-day/m-p/1357085#M10216 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have to calcul rate and i use this in the script :</P><P></P><P>(sum(value)/ day((Date)) ) as Rate</P><P></P><P>Now i need to replace day(date) by the last day of the month </P><P></P><P>Thanks for help</P><P></P><P>Regards</P></BODY></HTML> Wed, 03 May 2017 11:23:33 GMT https://community.qlik.com/t5/Management-Governance/calcul-rate-using-the-last-day/m-p/1357085#M10216 zied_ahmed1 2017-05-03T11:23:33Z Re: calcul rate using the last day https://community.qlik.com/t5/Management-Governance/calcul-rate-using-the-last-day/m-p/1357086#M10217 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14938112253499337 jive_text_macro" jivemacro_uid="_14938112253499337"> <P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(value)/</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Day(MonthEnd(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Date</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">))</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> AS Rate</SPAN></P> </PRE><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Wed, 03 May 2017 11:33:53 GMT https://community.qlik.com/t5/Management-Governance/calcul-rate-using-the-last-day/m-p/1357086#M10217 rahulpawarb 2017-05-03T11:33:53Z