doubt about set expresion

[dcd123456]

Hello

i have a table with three columns Id, Date and Value, i need create a text objet that show the avg of the items that have a date in the current month. I try to use this expresions but don't work

ID	Date	Value
2000000001	05/04/2014	12
2000000003	08/06/2014	34
2000000004	05/04/2014	1
2000000006	15/05/2014	34
2000000007	01/06/2014	56
2000000008	05/05/2014	123
2000000009	08/05/2014	6
2000000010	05/04/2014	2

Text Object:

='AVG Current month:  ' &avg({<Date={'month(today())'} >} Value)

or

='AVG Current month:  ' &avg({<month(Date)={'month(today())'} >} Value)

the first expresion don't return any value and the second show error...

i have attached an excample, anybody could help me.

thanks

regards

diego

[tresesco · Accepted solution]

Create a month field in the script, like:

Load

          Month(Date) as Month

Then, try like: ='AVG Current month:  ' &avg({<Month={'$(=month(today()))'} >} Value)

[Anonymous]

Try this:

avg(if(InMonthToDate(Date,today(),0),Value))

[mahesh_agrawal]

Hi,

Use the following expression. It will work.

=avg({$<Date={'>=$(=makedate(2014,month(today()),01))'}>}Value)