Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Calculation for My Plan B


Recommended Posts

Help me, I'm struggling with the process I want to achieve.
Here is the process for setting the amounts in my Plan B:

image.png.58d432074f38c46b8fe55eebb7dec662.png
I have a field for the Enrolment Fee with an amount of 715, which I will subtract from the Total School Fee of 21,605. The total difference of 20,890 will be divided by 8, resulting in 2,611.25. Let's assume this amount is 2,620. Now, this 2,620 needs to be set for the month of September. 
Like this:

image.png.c9485eaf6bf2e87e04af80790a4bd57e.png

The next step, to set the amount for the month of October, is to subtract the amount of September ( 2,620 ) from the Miscellaneous Fee that has an amount of 3,400. So the total difference is 780. So here's what i want to happen,  I want to set an amount of 2,610 for the months of October to May. Therefore, I need to subtract an amount from the Tuition Fee that has an amount of 16,440 and add it to the 780 to make it 2,610. 
Then repeat the process of subtracting the amount from the Tuition Fee until the amount of 2,610 is set for each month from October to May.

What calculation or script that I need to get this process perfectly? Thanks in advance.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.