Skip to main content
Solved

Combining Actuals and Forecast with Different Dimension

  • September 4, 2024
  • 1 reply
  • 125 views
S
Author
Forum|alt.badge.img+1

Hi! I’m currently working on a table where I need to combine my Actuals and Forecast. For context, these are the dimensions available:

Actuals

  1. Vendor
  2. GL Account
  3. Country
  4. Currency
  5. Month

Forecast

  1. Vendor Name
  2. GL Account
  3. Country
  4. Currency 
  5. Month
  6. Project Details

I’m having an issue because when I combine them, the Project Details dimension is being applied to every Vendor in my Actuals. Is there a way that I can combine them without removing the Project Details? We still want to see it especially if we don’t have an actual vendor yet. Thank you in advance for your help!

Best answer by Lehtohen

Hey Suzzy,

One thing you can do is add a new item in your Project Details list dimension called “BLANK”. 

Then you can update you formula to this:
IF(‘Is Actual’, MET_Actuals[BY:’Project Details’.”BLANK”], MET_Forecast).

This way all your actuals would be summed to this dummy-project. 

 

Hope this helps :)

1 reply

Lehtohen
Master Trendsetter
Forum|alt.badge.img+2
  • LehtohenMaster Trendsetter
  • Master Trendsetter
  • Answer
  • September 5, 2024

Hey Suzzy,

One thing you can do is add a new item in your Project Details list dimension called “BLANK”. 

Then you can update you formula to this:
IF(‘Is Actual’, MET_Actuals[BY:’Project Details’.”BLANK”], MET_Forecast).

This way all your actuals would be summed to this dummy-project. 

 

Hope this helps :)

Lehtohen
S

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement