Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Try with double quotes (" ") as they're used in modifiers for evaluated values.
=Sum({<Target_Year = {"$(=Year(Date(Sales_Date)))"}>}Target_Value)
What is your expected outcome ?
Can you elaborate more