Hi Folks, I hope you guys are having a great time.
I am working on a localization budget for a client , and they process payment per Episode not per title.
a title could start in 2021 and end in 2022, so we should process this in 2 separate times.
1- from release date ( Available field ) let’s say 1/10/2021 till end year 31/12/2021 ( End of current Year
2- From Start of the new year till the Last episode release date ( available field ) let’s say 18/2/2022 ( End of New Year for last eps date )
We will be able to calculate No of days between the start and end of current year and calculate no of days between start of the new year till the last episode release date . I have added 2 new fields
1- Days before Year start ( should include No of days between the start and end of current year)
2- Days after Year Start ( Should include days between start of the new year till the last episode release date)
I will then convert those days against the total days between release and last eps date and make a percentage then I will replicate that and conclude a cost for both values.
Appreciate the help , Thank you in advance.