Set Expression - Sum of Current Financial Year Sales

[#1]

Hi,

I am trying to sum the current financial year sales.

I have tried the below expression but I just get - back.

=sum({1<FinancialYear = max(FinancialYear)>}Sales)

If I enter the year 2015 I get the correct results, however I don't want to have to hardcode the current financial year.

=sum({1<FinancialYear = {2015}>}Sales)

Am I on the right track?

Thanks in advance for your help.

Jordan

[aveeeeeee7en · Accepted solution]

Try this:

=sum({1<FinancialYear ={'$(=Max(FinancialYear))'}>}Sales)

Regards

Av7eN

[aveeeeeee7en]

See the Attachment.

[senpradip007]

Try this:

sum({1<FinancialYear ={$(=Max(FinancialYear))}>} Sales)

[#5]

Awesome, Thanks Mate