should be the calculated as [prior year service days]/[total serivce days]% of functional amount of this transaction.
how can i calculate help me
starting date ending date Sum of functional_amount
02/02/2022 27/02/2022 2578.0
23/04/2022 23/05/2022 -3456.00
12/03/2033 23/04/2023 -5423.087
Could you define [prior year service days] and [total service days]?
Just counting the calendar days, or do you consider weekends and specific holidays?