Compare year values from two columns

[Anonymous]

Hi,

I have a requirement to compare year values from two columns for a chart. i tried using the below but its not working.

count({<[Year of Expense]={"=[Year of Expense]=[Scheduled Year]"}>} Status)

Any help is much appreciated. Thanks!

[sunny_talwar · Accepted solution]

May be this:

Count({<UniqueIdentfier = {"=[Year of Expense]=[Scheduled Year]"}>} Status)

Here replace UniqueIdentifier with a field that uniquely identify each single row of your table

[Anonymous]

Thanks a lot..