How to use max(date) in set analysis?

[narband2778]

Hi,

I want to count  total "orderID" of max(date) in set analysis? Without using a variable? Is this possible?

Many Thanks,

Naresh

[albertovarela]

Try this: count( {$ < date = {"$(=max(date))"} > } orderID) , you may want to add a Distinct depending on your data...

[narband2778]

Hi,

Thanks for the answer, I tried it but it did not work.

However the replacement of the $ sign after the curly brace  worked.

=count($ { < date = {"$(=max(date))"} > } orderID)

Thanks,

Naresh

[jaimeaguilar]

Hi,

sometimes happens that  you need to force date format, otherwise Set analysis doesn't recognizes numeric values:

=count($ { <date = {'$(=date(max(date)))'} > } orderID)

also just as a tip, usually single quotes are used for expanding a formula, while double quotes are used for executing searches,

regards

[MK_QSL]

COUNT({<date = {'$(=Max(date))'}>}Distinct OrderID)

or

COUNT({<date = {'$(=Max(date))'}>}OrderID)