Galera,
So, I have a little problem to write an expression, I've lost a few hours and I can not evolve.
The situation is as follows: I have 2 filters, one of Month and one of Year. It turns out that I need to bring the value based on a test of dates, and IF today's date is greater than the date of the last month of the filtered year I want the calculation is done based on the date of the last month and year filtered, otherwise I want it to be done based on the current month and year (today).
Soon % test is working correctly, because True and False appear in the situations I need.
So, if I filter 2017 the count will be based on 12/2017 regardless of the selected month. If I filter 2018 it should rely on 06/2018 because it is the month we are today, regardless of the month it is filtered.
The problem occurs when I include the count expression, it gives an error and I can not solve it.
if(today() > YearEnd(CALENDARIO.MESANO,0),'VERDADEIRO','FALSO')
My problem is occurring when I try to pass the date on CALENDAR.MESANO . Anyone have any ideas?