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
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
Last edited: