Hey Vico, 

Just try the following:

'Budget 2024'.AmounttFILTER: 'Budget 2024'.'Load Type' IN ('Load Type'."Budget TopLine",'Load Type'."Budget Other Costs")]]BY SUM: 'Budget 2024'.'Country Input'.'Country Pigment', 'Budget 2024'.Month, 'Budget 2024'.Product, 'Budget 2024'.Service, 'Budget 2024'.'Budget Line']
 

In the IN-statement you want to reference only items in a dimension list so you don’t want to add the “Budget 2024” in there. 

Below is a screenshot from an example metric:

Hope this helps :)

Hi! 

It’s working now, but it says this: 

Maximum cardinality exceeded (62,568,518,769 > 1,000,000,000)

Does it mean that I need to add more dimensions?

Vico

Hi @Vico,

Maybe this is because your metric structure isn’t matching the dimensionality of your formula. You might have  formula warning specifying which dimensions have been added and which have been removed if any.

You can use the formula playground and past your formula inside it, it will automatically evaluates the dimensions needed based on the properties of your transaction list 'Budget 2024'.

In your case you should have the following dimension : ‘Country Pigment’ , ‘Month’, ‘Product’, ‘Service’, ‘Budget Line’

Hope this helps,

It worked  @CDALMAY!!! you’re awesome!!!

Thank you so very much!

Just a small note to tell you how much we, at Pigment, enjoy reading this kind of conversations where users are helping other users! This is simply why we created this Community! 

Many thanks to all of you! Keep rocking! 

hey @Lehtohen,

I just encountered the same error with a different metrics and thanks to your example I could quickly solve it!!

thank you so much!