topic Re: Use Quarter Rate for all months in Quarter in App Development https://community.qlik.com/t5/App-Development/Use-Quarter-Rate-for-all-months-in-Quarter/m-p/2098988#M89979 <P>Assuming you also have a QuarterYear field</P> <P>1)&nbsp; sum(Amount*Rate_month)</P> <P>&nbsp;</P> <P>2)&nbsp;sum(Amount)*max(total &lt;QtrYear&gt; Rate_Quarter)</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vinieme12_0-1690881144070.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/113295i5BCCC169A55347C6/image-size/large?v=v2&amp;px=999" role="button" title="vinieme12_0-1690881144070.png" alt="vinieme12_0-1690881144070.png" /></span></P> <P>&nbsp;</P> Tue, 01 Aug 2023 09:12:59 GMT vinieme12 2023-08-01T09:12:59Z Use Quarter Rate for all months in Quarter https://community.qlik.com/t5/App-Development/Use-Quarter-Rate-for-all-months-in-Quarter/m-p/2098954#M89975 <P>Hi,</P> <P>Can you please help me calculating Amount for months in Quarter based on Quarter rate.</P> <P>Below is sample table:</P> <TABLE width="496"> <TBODY> <TR> <TD width="48">&nbsp;</TD> <TD width="56">&nbsp;</TD> <TD width="83">&nbsp;</TD> <TD width="90">&nbsp;</TD> <TD colspan="2" width="219">Output</TD> </TR> <TR> <TD>Month</TD> <TD>Amount</TD> <TD>Rate_month</TD> <TD>Rate_Quarter</TD> <TD>Amount_Month</TD> <TD>Amount_Quarter</TD> </TR> <TR> <TD>April</TD> <TD>100</TD> <TD>1</TD> <TD>&nbsp;</TD> <TD>100</TD> <TD>300</TD> </TR> <TR> <TD>May</TD> <TD>100</TD> <TD>2</TD> <TD>&nbsp;</TD> <TD>200</TD> <TD>300</TD> </TR> <TR> <TD>Jun</TD> <TD>100</TD> <TD>3</TD> <TD>3</TD> <TD>300</TD> <TD>300</TD> </TR> <TR> <TD>Total:</TD> <TD>300</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>600</TD> <TD>900</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>We have individual rate for each month and Quarter rate is considering the max month rate.</P> <P>While calculating the amount, for month wise calculation need to to monthly rate.</P> <P>But for Quarter amount calculation, need to use max month rate for all months in Quarter.&nbsp;</P> <P>Please help me to achieve&nbsp; Quarter Amount.</P> <P>your help is highly appreciated.</P> <P>Thank you.</P> Fri, 15 Nov 2024 21:31:37 GMT https://community.qlik.com/t5/App-Development/Use-Quarter-Rate-for-all-months-in-Quarter/m-p/2098954#M89975 bhargavikn 2024-11-15T21:31:37Z Re: Use Quarter Rate for all months in Quarter https://community.qlik.com/t5/App-Development/Use-Quarter-Rate-for-all-months-in-Quarter/m-p/2098988#M89979 <P>Assuming you also have a QuarterYear field</P> <P>1)&nbsp; sum(Amount*Rate_month)</P> <P>&nbsp;</P> <P>2)&nbsp;sum(Amount)*max(total &lt;QtrYear&gt; Rate_Quarter)</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vinieme12_0-1690881144070.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/113295i5BCCC169A55347C6/image-size/large?v=v2&amp;px=999" role="button" title="vinieme12_0-1690881144070.png" alt="vinieme12_0-1690881144070.png" /></span></P> <P>&nbsp;</P> Tue, 01 Aug 2023 09:12:59 GMT https://community.qlik.com/t5/App-Development/Use-Quarter-Rate-for-all-months-in-Quarter/m-p/2098988#M89979 vinieme12 2023-08-01T09:12:59Z Re: Use Quarter Rate for all months in Quarter https://community.qlik.com/t5/App-Development/Use-Quarter-Rate-for-all-months-in-Quarter/m-p/2099438#M90009 <P>Thank you Vineeth for solution. It is working.</P> Wed, 02 Aug 2023 09:17:31 GMT https://community.qlik.com/t5/App-Development/Use-Quarter-Rate-for-all-months-in-Quarter/m-p/2099438#M90009 bhargavikn 2023-08-02T09:17:31Z