Skip to Content
0
Sep 07, 2023 at 02:30 AM

How to calculate a MTD Plan in Datasphere?

150 Views Last edit Sep 07, 2023 at 02:31 AM 2 rev

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