Formula Field - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

mil0n023

New Member

Posts: 0

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?????

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

8/17/2006 5:05 PM

Your formula doesn't include NthLargest, so I'm not sure what you're talking about.

mil0n023

New Member

Posts: 0

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...

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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...