Expression

[rathnam_qv]

Hi all,

I have id's for Two months.but i need to get Current Month Id by Using Set Analysis.

can any one Help me

Thanks in advance

smiley

[er_mohit]

only({$<Month={"=$(=month(today()))"}>}id)

[NavinReddy]

Sum({<[Month]={"$(=Month(Today()))"}>} Sales)

sum(<$(=monthstart(today(),-1))

try this

[nilesh_gangurde]

Please use the below mentioned Expression.

Count( {<IDs = p({<MonthField = {"$(=MAX(MonthField))"}>})   >} Distinct IDs)

-Nilesh