topic Re: Expression not Working in App Development

Expression not Working

MattReinders — Tue, 18 Dec 2018 17:45:45 GMT

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

Re: Expression not Working

m_woolf — Tue, 18 Dec 2018 18:15:41 GMT

Try:

{'$(vCurrentYear)'}

Re: Expression not Working

MattReinders — Tue, 18 Dec 2018 18:20:41 GMT

That did not solve the issue.

Re: Expression not Working

m_woolf — Tue, 18 Dec 2018 18:44:27 GMT

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.

Re: Expression not Working

rwunderlich — Tue, 18 Dec 2018 19:35:57 GMT

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

-Rob

Re: Expression not Working

MattReinders — Tue, 18 Dec 2018 22:35:34 GMT

Figured it out. Thanks all.

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