Hi Team,
We have the daily fees data as per date ranges. If we have two different dates (in and out) and how can we calculate total fees by referring the table.
I have attached my manual calculation and expected result by referencing the fees table. thanks.
Regards,
Aye
Hi Aye,
Since the fees vary from one period to the next, you have to build a table as you've done to calculate the rate x the number of dates in the period and then add them up to get your total. There's no shortcut or single formula for this.
Mynda
Thanks, Mynda.
Kind Regards,
Aye
Hi Aye,
Perhaps a better way to do this is with Power Query. That way any updates to the date ranges can be automatically picked up and included in your query results.
Alternatively, if you don't expect the table to grow to include new dates, then you could hard key them into a LAMBDA function that performs the calculation. There's an example on my LAMBDA function page with income tax calculations that are similar to what you need to do.
Mynda
Many Thanks, Mynda,
I will prefer to use power query as my table will grow over time.
If possible, can you please direct me to relevant Power query session to refresh.
Thank you.
Regards,
Aye
Thanks, Mynda.
I will check.
Regards,
Aye
