I have a payment tracking table. It has fields that are Original Cost, Variable Cost, and Fields for each month(Jan - Dec): Formula Field). The original cost is linked from another table. If the user does not provide any value to Variable cost, The original cost value will be split into 12 months in respective fields for each month. Otherwise Variable cost value will be split for each month.
But my requirement is User can add the cost for each month manually if the client has paid a different amount for each month So that we can calculate the balance amount for the rest of the month.
