count of records for max date

[#1]

Hi All,

I am trying to display the count of records in a text box.

My expression is

=COUNT({$<MER_MATCH_MASK={'1'},RUN_DATE={"=$(=vMaxDate)"}>}MTR_ID);

where vMaxDate=Max(Date)

but it just returns zero.

Thanks in advance,

Anju

[jonathandienst]

Hi

Add a date function:

=COUNT({$<MER_MATCH_MASK={'1'}, RUN_DATE={"=$(=Date(vMaxDate))"}>} MTR_ID);

HTH

Jonathan

[#3]

Hi Jonathan,

Thanks for replying.

But, it did not work.

[jagan · Accepted solution]

  Hi Anju,

Try this

=Count({<Date={'$(vMaxDate)'}>} Date)

Make sure both date formats are same

Regards,

Jagan.

[#5]

Try this

=Count(If(Date=vMaxDate,D_Plant))

Where vMaxDate=Max({1}Date)

[jonathandienst]

Hi

Its possible that the format of RUN_DATE is not the default format for your environment (see the SET DateFormat statement at the top of your script). You need to format the vMaxDate value in same format as RUN_DATE.

For example, if RUN_DATE is in YYYY-MM-DD format, then use:

=COUNT({$<MER_MATCH_MASK={'1'}, RUN_DATE={"$(=Date(vMaxDate, 'YYYY-MM-DD'))"}>} MTR_ID);

Regards

Jonathan

[senpradip007]

Hi Anju,

try this:

Count({$<Date = {'$(vMaxDate)'} >} MTR_ID)

where vMaxDate = Max(Date).

Make sure that both the date format should be same.

[#8]

Hi Jonathan,

This did not work either..

[#9]

Thanks, Jagan!

It worked !

My expression looks like this

=Count({<MER_MATCH_MASK={'2'},RUN_DATE={'$(vMaxDate)'}>} MTR_ID)

[#10]

Hi Rajkumar,

I wanted to use set analysis.

I was already aware of the if condition syntax.

Thank You..