who can help to solve this problem?

Comments

• FRNL Hoogeveen - Netherlands

  April 2011 edited 12:11AM

  shellchan wrote: »

  firtly,my report like this:
  _______________________
  year jan feb ...
  1992 233 32 ...
  1993 76 198 ...
  ... ... ... ...
  2008 146 45 ...
  _______________________
  avg: 102.1 98.5 ...
  max: 233 198 ...
  max-year: 1992 1993 ...
  min: 76 32 ...
  min-year: 1993 1992 ...
  ________________________
  
  avg ,max ,min : i can use function avg(), max(),min()
  but, i can not implement max-year or min-year ,because max-year is dynamic value with month(jan,feb,...) who can help me ,how to solve it.
  give me script or setting method.
  
  thank you everyone !
  
  thank you everyone.

  
  I'm not sure if I understand the question
  Max(Yearof()) if you have month and date with it?
  
  Best regards,
  Teo