MAXIMUM value assistance

[LOUM]

Hello Again,

I need assistance with my statement below. I have a field in it which is [Last Issue Date], I need the statement to look at that and only calculate off the maximum record as there will be multiple. How should I change this below?


if ([Last Issue Date] is null) then ('10') else

if ([Last Issue Date] between _add_days(current_date,-60) and _add_days(current_date,-31)) then ('30') else

if ([Last Issue Date] between _add_days(current_date,-90) and _add_days(current_date,-61)) then ('60') else ('0')

[LOUM]

The [last date Issued] is pulling by item number if that helps.

Lou

[LOUM]

Bump....anyone? This is really holding me up....      :-\

[MFGF]

You could try replacing [Last Issue Date] with maximum([Last Issue Date] for report) wherever it occurs in your expression. 

This assumes there is just one date for the whole report you are interested in.  If you have multiple rows with different dates within a grouped item, and you want to use the last date for the group, change the expression to be 'for [Your grouped item]' instead of 'for report'

Regards,

MF.

[LOUM]

Worked splendidly M'

Thank you,
Lou

:D :D :D :D :D :D :D

[MFGF]

Great news!  Glad you got it working :-)