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.Amount[FILTER: 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?
Best answer by Helen Vuletin
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?
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?
