Sales plan for the organization is loaded on the first day of the month (e.g. 9/1/2023) only and we need to be able to track the actual sales MTD against plan MTD. This means the sales plan needs to be pro-rated as on the day actuals are being reported. For example, on a given day, the pro-rated plan should be (Full month plan * Days past in the month / Total number of days in month).
Can someone help with how to model this in Datasphere or in SAC? In BEx, this is easily done using formula variables.
Any help is highly appreciated.
AS