need help with this query

[pruthveej]

am working on impromptu and i have a problem . i have a query as below for MAX and MIN :

ALERT MIN: lookup(trim-trailing (cycle type)) in ('AZOPT L'--->499,'BALLM DRY' -->71,'DRY GOODS'-->48,'ECON 4 CAR'--> 752,'econopred'-->718,'otic'--> 1421,'vexol'-->954)default null.

ALERT MAX: lookup(trim-trailing (cycle type)) in ('AZOPT L'--->510,'BALLM DRY' -->85,'DRY GOODS'-->65,'ECON 4 CAR'--> 795,'econopred'-->795,'otic'--> 0,'vexol'-->1034)default null

for the graph reports.

i need to change the MAX and MIN for few EQUIPMENT numbers for FEW CYCLE TYPES like this:

AU-P01    ECONO 4 CAR cycle: ALERT MAX- 805,
AU-PO2   DRY GOODS CYCLE: ALERT MIN- 49,
AU-P11  AZOPT L CARBOY CYCLE: ALERT MIN-499

Can u kindly let me know correct query for MAX and MIN for my Cycle type please.

i have been working on this for a while but am not able to get the correct query. can u kndly let me know the correct query please. am i deep trouble bcoz of this. Am new to this impromptu.
Reply