set analysis

[Anonymous]

Hi,

I am using the function -

sum( {$<MonthName = {May}, system= {Y,X}>} [QUANT] )/1000

But what I realy want is the month not to be May, but to be the current month.

How should I checged the syntex of the function?

Thanks!

[datanibbler]

Hi,

to replace May with the current month, you can use an expression within your set_expression.

The syntax is >> {"$(=Month(Today()))"} <<

<=> Check that in a textbox on the GUI first to make sure that Month(Today()) really does return the name of the month and not just a numeric value.

HTH

[jonathandienst · Accepted solution]

Perhaps

sum( {$<MonthName = {"$(=Month(Today()))"}, system = {Y,X}>} [QUANT]) / 1000

[jonathandienst]

Month(Today())) will return a dual with text of the month name and numeric value of the month number.

[Anonymous]

thank you

It worked!