1 of 1 people found this helpful
Welcome to the forum.
Here is one idea.
The % operator returns the remainder of a division operation. For example, 9 % 2 returns 1 because 2 goes into 9 four times with a remainder of 1. Modulo can only operate on integers.
Thank you! Your solution is awesome for this case and also helped me a lot to understand logic behind calc. fields used to reach the solution.
I added an additional calculated field to filter CY and LY
IF [Year Of Calendar]=YEAR(TODAY()) OR [Year Of Calendar]=YEAR(TODAY())-1
THEN 'True' ELSE 'False' END
You are welcome and I hope you enjoy the forum.