Expression not Working

[MattReinders]

Hello All,

This may seem very straight forward. I have the following expression to sum Payment Category (Cash) on the current year. 

Expression: 

= num(sum({<[Fiscal Year] = {$(=vCurrentYear)} >} [Payment Category]='Cash'), '$#,##0')

I am not getting the correct number when this expression executes. Is there something incorrect with how I have written the above expression?

Thanks,

Matt

[m_woolf]

Try:

 {'$(vCurrentYear)'}

[MattReinders]

That did not solve the issue. 

[m_woolf]

It seems like [Payment Category]='Cash' should be part of the Set Analysis and there should be another field to sum (Amount). Hard to say without seeing your data model.

[rwunderlich]

Your syntax is incorrect.  What field are you trying to Sum?

-Rob

[MattReinders]

Figured it out. Thanks all. 

=num(sum({<[Fiscal Year] = {'$(vCurrentYear)'},[Payment Category]={'Cash'}>} [Expense Amount USD]),'$#,##0')