• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Interest Amount

Status
Not open for further replies.

ashish mehra

Active Member
Hi,

I have attached sample dataset in Data worksheet. Desired output is mentioned for Loan A/C ACXXX01 in Required Output worksheet.

Calculation is done in Pivot Report worksheet.

Here logic is:

For Loan A/C ACXXX01; Start Date = Report Run Date - DPD / Ageing
Output will be 24 days of April month + May to Aug month interest due.

Please give the output for Loan A/C ACXXX02

Regards,
AM
 

Attachments

  • Sample v2.xlsx
    18.9 KB · Views: 7
Last edited:
Status
Not open for further replies.
Back
Top