Joined: 27 Apr 2012
Location: United States
Online Status: Offline
Posts: 140
Topic: Max Date on Group Created by Formula Posted: 14 Sep 2016 at 7:48am
I am using Crystal 2011. I'm attempting to pull in the Max date on a group I've defined. The report is grouped by Employee ID, then by my custom group. Below is my formula for the custom group:
If(reviewcode)startswith "LVL1I" or (reviewcode)startswith "LVL1A" then 1 else
If(reviewcode)startswith "LVL2" then 2 else
If(reviewcode) startswith "LVL3" then 3 else
If(reviewcode) startswith "LVL4" then 4 else
If(reviewcode)startswith "LVL5" then 5
The max date is returning successfully except for anything categorized as 1. I'd expect to return the max date regardless if a reviewcode was "LVL1I" or "LVL1A", but it returns the max date for only anything as "LVL1I".
How can I get the report to return the max date for anything categorized as 1?
Edited by thummel1 - 14 Sep 2016 at 7:49am
"Press any key to continue. Where's the 'Any' Key?" ~Homer Simpson
Joined: 27 Apr 2012
Location: United States
Online Status: Offline
Posts: 140
Posted: 14 Sep 2016 at 10:09am
For those looking, I may have found the culprit. My date field is formatted like a string and not as a date, so it's not going to read properly I think. I will look at fixing that and then trying to run this.
"Press any key to continue. Where's the 'Any' Key?" ~Homer Simpson
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged