https://community.qlik.com/t5/App-Development/Calculating-Interest-for-the-balance-at-month-end/m-p/2049394#M86251 <P>How do I calculate interest at the end of each monthyear for the Balance and showing at the end of the period.&nbsp;</P> <TABLE width="264"> <TBODY> <TR> <TD width="44">MonthYear</TD> <TD width="60">SalaryDate</TD> <TD width="52">ContibutionType</TD> <TD width="54">Amount</TD> <TD width="54">Balance</TD> </TR> <TR> <TD width="44">02/2020</TD> <TD width="60">29/02/2020</TD> <TD width="52">Opening Balance</TD> <TD width="54">658005.3</TD> <TD width="54">658005.3</TD> </TR> <TR> <TD width="44">03/2020</TD> <TD width="60">01/03/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1633.28</TD> <TD width="54">659638.6</TD> </TR> <TR> <TD width="44">03/2020</TD> <TD width="60">01/03/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">978.17</TD> <TD width="54">660616.7</TD> </TR> <TR> <TD width="44">04/2020</TD> <TD width="60">01/04/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1633.28</TD> <TD width="54">662250</TD> </TR> <TR> <TD width="44">04/2020</TD> <TD width="60">01/04/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">978.17</TD> <TD width="54">663228.2</TD> </TR> <TR> <TD width="44">05/2020</TD> <TD width="60">01/05/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1633.28</TD> <TD width="54">664861.5</TD> </TR> <TR> <TD width="44">05/2020</TD> <TD width="60">01/05/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">978.17</TD> <TD width="54">665839.6</TD> </TR> <TR> <TD width="44">06/2020</TD> <TD width="60">01/06/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1633.28</TD> <TD width="54">667472.9</TD> </TR> <TR> <TD width="44">06/2020</TD> <TD width="60">01/06/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">978.17</TD> <TD width="54">668451.1</TD> </TR> <TR> <TD width="44">07/2020</TD> <TD width="60">01/07/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">669716.2</TD> </TR> <TR> <TD width="44">07/2020</TD> <TD width="60">01/07/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">670874.7</TD> </TR> <TR> <TD width="44">08/2020</TD> <TD width="60">01/08/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">672139.7</TD> </TR> <TR> <TD width="44">08/2020</TD> <TD width="60">01/08/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">673298.3</TD> </TR> <TR> <TD width="44">09/2020</TD> <TD width="60">01/09/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">674563.3</TD> </TR> <TR> <TD width="44">09/2020</TD> <TD width="60">01/09/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">675721.8</TD> </TR> <TR> <TD width="44">10/2020</TD> <TD width="60">01/10/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">676986.9</TD> </TR> <TR> <TD width="44">10/2020</TD> <TD width="60">01/10/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">678145.4</TD> </TR> <TR> <TD width="44">11/2020</TD> <TD width="60">01/11/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">679410.5</TD> </TR> <TR> <TD width="44">11/2020</TD> <TD width="60">01/11/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">680569</TD> </TR> <TR> <TD width="44">12/2020</TD> <TD width="60">01/12/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">681834.1</TD> </TR> <TR> <TD width="44">12/2020</TD> <TD width="60">01/12/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">682992.6</TD> </TR> <TR> <TD width="44">01/2021</TD> <TD width="60">01/01/2021</TD> <TD width="52">Nett Member</TD> <TD width="54">1048.57</TD> <TD width="54">684041.2</TD> </TR> <TR> <TD width="44">01/2021</TD> <TD width="60">01/01/2021</TD> <TD width="52">Nett Company</TD> <TD width="54">940.56</TD> <TD width="54">684981.7</TD> </TR> </TBODY> </TABLE> Wed, 15 Mar 2023 09:28:29 GMT BeesKnees 2023-03-15T09:28:29Z https://community.qlik.com/t5/App-Development/Calculating-Interest-for-the-balance-at-month-end/m-p/2049394#M86251 <P>How do I calculate interest at the end of each monthyear for the Balance and showing at the end of the period.&nbsp;</P> <TABLE width="264"> <TBODY> <TR> <TD width="44">MonthYear</TD> <TD width="60">SalaryDate</TD> <TD width="52">ContibutionType</TD> <TD width="54">Amount</TD> <TD width="54">Balance</TD> </TR> <TR> <TD width="44">02/2020</TD> <TD width="60">29/02/2020</TD> <TD width="52">Opening Balance</TD> <TD width="54">658005.3</TD> <TD width="54">658005.3</TD> </TR> <TR> <TD width="44">03/2020</TD> <TD width="60">01/03/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1633.28</TD> <TD width="54">659638.6</TD> </TR> <TR> <TD width="44">03/2020</TD> <TD width="60">01/03/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">978.17</TD> <TD width="54">660616.7</TD> </TR> <TR> <TD width="44">04/2020</TD> <TD width="60">01/04/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1633.28</TD> <TD width="54">662250</TD> </TR> <TR> <TD width="44">04/2020</TD> <TD width="60">01/04/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">978.17</TD> <TD width="54">663228.2</TD> </TR> <TR> <TD width="44">05/2020</TD> <TD width="60">01/05/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1633.28</TD> <TD width="54">664861.5</TD> </TR> <TR> <TD width="44">05/2020</TD> <TD width="60">01/05/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">978.17</TD> <TD width="54">665839.6</TD> </TR> <TR> <TD width="44">06/2020</TD> <TD width="60">01/06/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1633.28</TD> <TD width="54">667472.9</TD> </TR> <TR> <TD width="44">06/2020</TD> <TD width="60">01/06/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">978.17</TD> <TD width="54">668451.1</TD> </TR> <TR> <TD width="44">07/2020</TD> <TD width="60">01/07/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">669716.2</TD> </TR> <TR> <TD width="44">07/2020</TD> <TD width="60">01/07/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">670874.7</TD> </TR> <TR> <TD width="44">08/2020</TD> <TD width="60">01/08/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">672139.7</TD> </TR> <TR> <TD width="44">08/2020</TD> <TD width="60">01/08/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">673298.3</TD> </TR> <TR> <TD width="44">09/2020</TD> <TD width="60">01/09/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">674563.3</TD> </TR> <TR> <TD width="44">09/2020</TD> <TD width="60">01/09/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">675721.8</TD> </TR> <TR> <TD width="44">10/2020</TD> <TD width="60">01/10/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">676986.9</TD> </TR> <TR> <TD width="44">10/2020</TD> <TD width="60">01/10/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">678145.4</TD> </TR> <TR> <TD width="44">11/2020</TD> <TD width="60">01/11/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">679410.5</TD> </TR> <TR> <TD width="44">11/2020</TD> <TD width="60">01/11/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">680569</TD> </TR> <TR> <TD width="44">12/2020</TD> <TD width="60">01/12/2020</TD> <TD width="52">Nett Member</TD> <TD width="54">1265.08</TD> <TD width="54">681834.1</TD> </TR> <TR> <TD width="44">12/2020</TD> <TD width="60">01/12/2020</TD> <TD width="52">Nett Company</TD> <TD width="54">1158.51</TD> <TD width="54">682992.6</TD> </TR> <TR> <TD width="44">01/2021</TD> <TD width="60">01/01/2021</TD> <TD width="52">Nett Member</TD> <TD width="54">1048.57</TD> <TD width="54">684041.2</TD> </TR> <TR> <TD width="44">01/2021</TD> <TD width="60">01/01/2021</TD> <TD width="52">Nett Company</TD> <TD width="54">940.56</TD> <TD width="54">684981.7</TD> </TR> </TBODY> </TABLE> Wed, 15 Mar 2023 09:28:29 GMT https://community.qlik.com/t5/App-Development/Calculating-Interest-for-the-balance-at-month-end/m-p/2049394#M86251 BeesKnees 2023-03-15T09:28:29Z