Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Formula Field

Sort:
You are not authorized to post a reply.
Author
Messages
mil0n023
Veteran Member
Posts: 63
Veteran Member
8/17/2006 4:42 PM
    Hey John - or anyone!

    I am using a formula field to display "N/A" text on a bad date in lawson review - but thought I had it set to give me the Nth Largest of a review Date. It doesn't. Here is the formula:

    if{REVIEW.ACTUAL_DATE} = CDateTime (1700, 01, 01, 00, 00, 00) then totext
    ("N/A") else totext({REVIEW.ACTUAL_DATE},"MM/dd/yyyy")

    It returns good data, and adds that feature for the "N/A" but I noticed on quite a few employee's that it does not give the most recent date. EX:
    Employee 1234, Last review 11/16/05 (had on 11/16/04) it is returning the '04 review date?????
    M. C. Miller
    Analyst
    Salem, Oregon
    John Henley
    Senior Member
    Posts: 3348
    Senior Member
    8/17/2006 5:05 PM
      Your formula doesn't include NthLargest, so I'm not sure what you're talking about.
      Thanks for using the LawsonGuru.com forums!
      John
      mil0n023
      Veteran Member
      Posts: 63
      Veteran Member
      8/17/2006 6:42 PM
        Well, that is the formula I created to return "N/A" for the irrelevant date, 1/17/1700 - so I plopped that formula field into the details section and did a NthLargest of this - and placed the results in the Group Header and supressed the details...
        M. C. Miller
        Analyst
        Salem, Oregon
        John Henley
        Senior Member
        Posts: 3348
        Senior Member
        8/17/2006 6:54 PM
          I think you should be putting the results in the group footer not the group header. Otherwise it's probably evaluating the previous employee when doing the NthLargest...
          Thanks for using the LawsonGuru.com forums!
          John
          You are not authorized to post a reply.