Skip to main content

Hi, 

I am looking to combine a transaction list (actuals) with a forecast metric using a cost centre dimension.

I have the cost centre dimension in my transaction actuals but in the forecast it is a property in another dimension (property type is dimension and selected as the same one in the actuals). 

What function should i be using in my formula in order to bring both in combined at the cost centre level?

 

Hi @MKSMPB 

You can use property chaining for that.
Assuming you have the following :

  • Actuals_Transaction_List with at least 2 Properties :  
  1. Cost_Center (Dimension Cost Center)
  2. Amount (As Number)
  • Forecast_Metric with at least 1 Dimension and Number as Data Type:
  1. Other_Dimension (Where this other dimension has a property Cost_Center)

You will end up with a formula like this :

IF(Set_Is_Actuals,

Actuals_Transaction_List.AmounttBY:Actuals_Transaction_List.Cost_Center],

Forecast_MetrictBY:Other_Dimension.Cost_Center]

)


Let me know if that makes sense


Thanks, looks like thats done the trick!


Reply