calculate considern month and year

[Alma]

Hello everyone,

I hope someone can help me ..

I want to calculate the hours when in colum "Type" the world "true" is, but this is not the problem. I want that the Calculation considern the year and the month, so that the claculation will not be for all the years and monthes where true ist 

I tried this but it did not worked .. Error error unrecognized symbol :{

Sum({<type={'true'}, year={"$(=Max(year))"}, month={"$(=Max(month))"}>} hours )

[TauseefKhan]

Hi @Alma 

likely due to incorrect syntax in your set analysis expression.

Check this one:

Sum({<Type={'true'}, Year={$(=Max(Year))}, Month={$(=Max(Month))}>} Hours)

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***

[Alma]

Hi @TauseefKhan 

thank you very much for you answer but it didn't work either

I do not know what to do, do you have any advice for me?

Thanks for your help