Sum of Revenue for a Year

[#1]

I'm working on creating an expression that returns only the revenue for the year selected in the listbox. Any suggestion?

[mdmukramali · Accepted solution]

Dear,

perform this expression

=sum( {$<Year = {$(=Only(Year))}>} Revenue )

hope this one will help you

thanks,

Mukram.

[#3]

I typed it in and it is not showing any data. Could you maybe break down the syntax for me? Thanks for helping!

[mdmukramali]

Dear,

Select Any year from listbox then it will show the Sum(Revenue) for that particular Year..

expression is  

=sum( {<Year={$(=Only(Year))}>}  Revenue)

thanks,

Mukram

[#5]

I have tried that to no result. Any clue as to what I might be doing wrong?

[mdmukramali]

Dear,

check the Spell and Year filed name same as Year.

else

can u post your applcation?

Thanks,

Mukram

[#7]

I figured out what I was doing wrong. I left out the second =    Thanks so much!!

[#8]

If I wanted to do the same thing for a month how would I do that?