Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 512
	Members: 0
	Total: 512

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

Formula Field

3 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

mil0n023

Veteran Member

Posts: 63

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: 3353

8/17/2006 5:05 PM

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

mil0n023

Veteran Member

Posts: 63

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: 3353

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