Set analysis - One criteria and Month

[#1]

Hello everyone,

I'm trying to set up a gauge chart where the sum if of a pre-set criteria and then linked to current month. Please can you put me right, the formula I am using is below where I want the sum to be where phase is equal to 'community' and current month.

sum({<PHASE='COMMUNITY',MONTH={"$(=monthstart(today()))"} >} VALUE)

With thanks,

Simon

[#2 · Accepted solution]

hello. quite good:

sum({<PHASE={'COMMUNITY'},MONTH={"$(=month(today()))"} >} VALUE)

[#3]

Thank you!

[#4]

WAS THE correct ANSWER? PLS QLIK ON IT

[#5]

All done, sorry couldn't see the button on the view I was earlier. Thank you, I'm now playing around with date fields in vFromDates so I may still break it!