Skip to main content

When I follow the training materials and the training videos provided, I have to create the REVENUE metric. So far so good, but when I enter the FILTER part in the formula, it does not accept it.

My formula: Transactions.AmounttFILTER: Transactions.Account.Category = "Revenues"]]By: Transactions.Account, Transactions.Country, Transactions.Month, Transactions.Team]

 

Error message: Error: Expressions are incompatible and cannot all be converted to Dimension ('Data Hub - JV'::'Account Category')

Can someone support me to guide me what I do wrong?

Hi Jan, thanks for pointing out these issues with the training materials and videos. We will update them as soon as we can. The filtering syntax was updated recently from Dim = "string" into Dim = Dim."string" or even just Dim."string" (new shorter syntax).

In the meantime, could you try this formula for your FILTER modifier?

Transactions.AmountmBY SUM: Transactions.Account, Transactions.Country, Transactions.Team, Transactions.Month]rFILTER: Account.Category = Category."Revenues"]

Please let me know how it goes. 

Helen

Hi Helen, thanks for there tip, it pointed me in the right direction. Small adjustment to your formula:

Transactions.Amount[BY SUM: Transactions.Account, Transactions.Country, Transactions.Team, Transactions.Month][FILTER: Account.Category = 'Account Category'."Revenues"]

 

That works! Thanks

Regards, Jan

Amazing! So glad it helped Jan. 

Cheers,

Helen

Reply


Ask your question here!

Terms & ConditionsCookie settings