Solved

How to align a property in one dimension with another dimension

  • 25 April 2024
  • 2 replies
  • 47 views

Userlevel 1
Badge

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?

 

icon

Best answer by CDALMAY 25 April 2024, 17:27

View original

2 replies

Userlevel 2
Badge +5

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.Amount[BY:Actuals_Transaction_List.Cost_Center],

Forecast_Metric[BY:Other_Dimension.Cost_Center]

)


Let me know if that makes sense

Userlevel 1
Badge

Thanks, looks like thats done the trick!

Reply