Calculation of Payment Frequecy

Options
Ashutosh
Ashutosh Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi All,

I've one use case where I've to calculated payment according to payment frequency i.e monthly, annually and quarterly.

I've system module dimensioned  by  lease where user enters lease start date, end date and payment frequency.

For e.g. Sr. No    Start date                End Date            Payment frequency

             Lease1    4th-May-2012      12th-july-2022          Quarterly

 

But I am facing issue to calculate payment because we are using only current year, Previous year and Future years. But in our case it's starts from 2012. So How we decide the quarter month  in 2021 and tick that months accordingly. We need it by Month. So target module dimensioned by Time(Months), Lease list.

 

Can anyone  help on this please?

Thanks

Ashutosh

Tagged:

Comments

  • Ashutosh
    Ashutosh Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    Hi Alex,

     

    Thank you for response. But We can't uses time ranges because sometimes selected date comes in past 20 years and it will increase size drastically. 

    That's the main problem. Is any other way to work around using formulas?

     

    Regards

    Ashutosh

Categories