Set Analysis

[rahulsingh12]

Hi,

How Should I write my expression if i want the last 6 months data to be selected from the current selected month?

Regards,

[sunny_talwar]

May be this

{<Date = {"$(='>=' & Date(MonthStart(Max(Date), -6), 'DateFieldFormatHere') & '<=' & Date(Max(Date), 'DateFieldFormatHere'))"}, Month>}

[rahulsingh12]

It is showing error in expression

[sunny_talwar]

No idea what you used, I just showed you how the basic syntax looks like...

[rahulsingh12]

{<Date = {"$(='>=' & Date(MonthStart(Max(Commondate), -6), ''mm/dd/yyyy'') & '<=' & Date(Max(commondate), 'mm/dd/yyyy'))"}, commonmonth>}

I have replaced it with the fields I have

Regards,

[sunny_talwar]

What is the expression you used my friend?

[rahulsingh12]

I am new to set so maybe not using the expression properly.

I have two fields Common month and Common year in the selection.

where should I fit it in the expression/

[sunny_talwar]

What was your expression where you were trying to implement this?

[rahulsingh12]

It was just count(A) that's it.

Regards,

[vishsaggi]

Based on your expr is this what you were trying?

= Count({<Date = {"$(='>=' & Date(MonthStart(Max(Commondate), -6), 'mm/dd/yyyy') & '<=' & Date(Max(commondate), 'mm/dd/yyyy')) }, commonmonth >} YourActualField)