Split an overall value data according to start date and end date

[Sunandha]

Dear Experts,

Need a solution for this scenario.

Eg, I have a contract with a building from 15.05.2023 - 14.05.2024. In this period I have got a contract amount of 1,25,000 as revenue. Now in my table I want to split this value for each month according to contract start date and end date to show my revenue of each month. 

Is it possible to achieve this in SAC .

Not really required with the same table format but the concept support is required.

Regards,

Sunandha

[N1kh1l]

@Sunandha 

Is it possible to achieve this in SAC ? -  Yes, Its possible using Advanced Formula DA. Maintain contract start date and end date as attributes in contract dimension in format YYYY-MM-DD. then you can check if date falls in his range of start date and end date you take the contract amount and distribute it equally in the date. What I did not understand from your table is why your Value of may and June are different if you are dividing equally.

Nikhil

[Sunandha]

Can you please explain more about the Advanced formula or may be a sample on how it works. It is because the contract starts from 15thMay so the revenue for May is calculated for 15 days. Is that level calculation also possible with this Advanced formula?

[N1kh1l]

Yes, You can use DAY() , DATEDIFF(), DAYSINMONTH() , Its not possible to provide you exact code as it will depend lot on how your model is and what dimensions are there. But refer to these time and date related function in SAC help documentation and it will give you the idea how to do it.