Formula to YEARVALUE with Actual months
Could you please help me with a topic? I have a module, where I need to calculate the average of my NET SALES for 2022, and that every month has the same value. I applied the YEARVALUE/12 formula and it works for Forecast months. However, for the current month, Anaplan brings me the Actual value and divides it by 12. And I need an FY average of that value. I already tried to make boolean IF ACTUAL THEN NEXT (Net Sales) ELSE YEARVALUE/12 but it doesn't help. Anaplan continues to bring me current values in January. Anyone have an idea how to do this?