Max Date in expression

[venkatg6759]

Hello ,

I need to include max date in expression . Can anyone help me how to write it.

I tried aggr(max)

Count({<Rating={'NR'}>}Rating)

I need to include max(Rating Date) into the above expression . I am using bar chart .

Thanks,

Venkata

[#2]

Is it max date of date selected, or maybe max date of some chart dimension?

regards

Darek

[venkatg6759]

Its max date of dimension which is called rating date

[#4]

Try to look here:

Problem creating the report to show only latest status of the project

Re: Re: Set analysis - count values for latest possible date

regards

Darek

[kangaroomac]

Hiya,

Maybe this will help:

=Count({$<Rating={'NR'},RatingDate={$(=Max(RatingDate))}>}Rating)

[jagan]

Hi,

Try this

=Count({<Rating={'NR'}, [Rating Date] = {'$(=Date(Max([Rating Date])))'}>}Rating)

Regards,

Jagan.