4 Replies Latest reply: May 18, 2018 3:21 AM by Andrea Gigliotti

# Calculate the sum of the current month

I need to calculate the sum of the current month:

Variable vCurrent_Month:

=Month(Today())

Sum({< Month_date = {"\$(vCurrent_Month)"}>} Visitors)

• ###### Re: Calculate the sum of the current month

=Month(Today()) is just going to give you 'May' as a result.

=Date(Today(),'MMM-YYYY') will give you the current month, just match the format string to month_Datesyntax.  The syntax is val

Edit: I've seen a lot of posts here recommending new syntax.  The syntax is valid, I worked it on my device. It's the output of the variable that's not matching whats in your dimension.

Andrew

• ###### Re: Calculate the sum of the current month

Hi Gustavo,

Variable vCurrent_Month:

Month(Today())

Remove "=" before Month().

sum({<Month_date ={'\$(=\$(vCurrent_Month))'}>}Visitors)

Regards,

Akshaya

• ###### Re: Calculate the sum of the current month

You may use Num(Month(Today())) = 5

• ###### Re: Calculate the sum of the current month

you can use the below expression:

Sum( {< Month_date = {"=Month(Today())"} >} Visitors )

Hope it helps.