Sum of Revenue for a Month

[#1]

I am trying to create an expression to display the sum of the revenue in a given month. I have succeeded in doing this for a year with the following expression: =sum( {$<Year = {$(=Only(Year))}>} Revenue )       What do I need to do to make this by month.

[deepakk]

hi,

Try using it in below way.

sum( {$<YearMonth = {$(=max(YearMonth))}>} Revenue )

where YearMonth is a field created in script as below

Year(Date) & num(Month(Date)),'00') as YearMonth

I hope this helps.

[jagan]

Hi,

Try this expression

=sum( {$<Year = {$(=Max(Year))}, Month = {$(=Max(Month))}>} Revenue )

Hope this helps you.

regards,

Jagan.

[v_iyyappan]

Hi,

     Use expression like this,

          = sum( {$<Year = {$(=Max(Year))}, MonthKey = {$(=Max(MonthKey))}>} Revenue )

Where  MonthKey in load script =(Month(Datafield) * 1)

Regards,

Iyyappan