Display sum value based on current month

[#1]

I have a data set where the fields are netaddresses, MonthAddress, YearAddress.  I would like to have a text object show the sum of the netaddresses column but only show values for the current month.  I have another list box that already is limiting the data by year but I want the text object to the sum of the current month using the year selected.  How would I do that?

[aveeeeeee7en]

Hi

For current Month you need to use Month(Today()) and Year(Today()) in your expression.

Try this:

='Current Month '&'('&Month(Today())&' - '&Year(Today())&')'&' Amount :'&chr(32)&chr(32)& Sum({<New_Month={'$(=Month(Today()))'},New_Year={'$(=Year(Today()))'}>}Amount)

Also, see the expression for understanding.

Regards

Aviral Nag

[#3]

Thanks for the reply.  I already have a list box to select the year, however I would only like the have the text object sum the netaddress values for the same current month.  Is that possible as I don't want to have to include the year in the expression?