ERROR FORMULA YEAR

[Geral]

WHAT CAN I DO TO MAKE THIS VALUE GIVE ME THE SAME, TO BE ABLE TO HAVE THIS CALCULATION OF THE MOST RECENT YEAR.

THIS IS THE TYPE OF VALUE THAT I HAVE

AND THE ERROR

[prantika_sinha]

Hi @Geral ,

Can you explain what are you intending to calculate?

Lets say if you want to calculate a measure reported in the current Year, then you can use

ifelse( parseInt(activity year)= extract(‘YYYY’,now() ), total ventas, 0)

Thanks,
Prantika