Hello Gurus,
I have a situation where I need to display the latest record using the Max(Date) function. Instead, the result I'm getting is the latest record for every category in the block. 😞 I've tried a bunch of stuff with variables and filtering and then finally turned to google. Unfortunately, I've remained stuck.
So I have 3 fields: Est#, InspDate, StatCode. When I throw them in a table I get every record:
When I use Max(InspDate), instead of getting the latest record for each est, I get the latest record for each StatCode as shown here:
What am I missing?
- SAP Managed Tags:
Accepted Solutions (0)
Answers (0)
| User | Count |
|---|---|
| 84 | |
| 10 | |
| 10 | |
| 9 | |
| 7 | |
| 6 | |
| 5 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.