Calculate rate increases based on financial year and start dates

[cowproduct]

Hello!

So I'm trying to set-up an auto formula for an apprentice scheme we have to allow us to quickly calculate rates and rate changes. Attached is a rough example of 1 made up person and made up rates.

I think the attachment is self explanatory as I have entered my requirements in red. Please let me know if anything is unclear on this.

Thanks!

[tuph]

You need more data so you can calculate the weeks. I have attached a sample. I hope it helps.

It isn't clear what you want in the Legend section.

[Cutter]

@ cowproduct

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.