Data has been stored under separate measure for 'Actuals' - one under ‘SAP value’ and other under ‘Final value’, due to the same certain visualizations (dashboards/graphs) are not appearing. For certain visualizations (dashboards/graphs), formula needs to contain future year, current year and previous year, however owing to them being under different measures, required graphs are not populating.
Please find the below formula
[#Actual PY-1 Amount] + [#Actual PY Amount] + [#Budget CY Amount] + [#Actual YTD Amount]+[#Estimate YTD]+[#Outlook CY Amount]+[#Budget FY Amount]
As per the formula the current year should take the SAP value & later the final value But after putting the combination, year is dynamic i.e FY24 will count as current year & they will pick the final value instead of SAP value , also we don’t have the sap value in fY24.
If we take one calculated measure i.e. calculation SAP value is null then value should pick as inputted final value. So, we are unable to take this calculated measure in restricted measure for the dynamic time functionality in planning model.
Thanks & regards,