Using a < (Less than) in Set analysis)

[#1]

Hello All,

I'm trying to include a < (Less Than) sign to denote that I want  all possible selections which fall before a selected date. However the formula does not seem to return any values. Has anyone ever done this succesfully? Any ideas what such a structure might fail?

The logic I'm trying to get to is:

If (purchase date <= selected date)

And

If (send date month = selected month)

Then

Sum(Revenue)

I hope this is clear. I could really use the help.

[SunilChauhan]

try this

sum({<[purchase date] = {"<$(Only([purchase date]))"}>} valuefield)

hope this helps

[#3]

Thanks for your answer but that does not help me. "Only" function returns a value only if a have one and only one selected value. In my case I think Max or MaxString will be a better option.

I tried this but It returns a null.

Sum({$<, Purchase_Date = {"<= $(=Max(SendDate)) "}>} Amount)

[#4]

I don't think you need that first "," try remoiving it.

Stephen

[#5]

Yes, you do need the quotes when using expressions like >= <= and similar.

[#6]

Just to clarify I'm talking about remove the first comma. Igor is right that you need the quotes.

[#7]

I have tried your suuggestions without getting different results. Thanks for your help so far.

[cesaraccardi]

Hi, I think you have different date formats... have you checked that?

[#9]

Thanks for the suggestion but they are formatted correctly. Both in terms of data format and date format.