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?
Best answer by CDALMAY
View original
+5
Hi
You can use property chaining for that.
Assuming you have the following :
Actuals_Transaction_List with at least 2 Properties : Forecast_Metric with at least 1 Dimension and Number as Data Type: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
Thanks, looks like thats done the trick!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.