I'm trying to show the most recent user note on a ...
# suiteanalytics
r
I'm trying to show the most recent user note on a custom record. Using Max Date on the results will just show the latest date of all user notes, but for every line, regardless of whether that does applies to that particular user note. A little help?
If I group the memo, it will have the behavior described above.
I think I need a formula... CASE WHEN {usernote.date} [is max date] {usernote.memo} ELSE null END
k
you'll have issues due to different summary levels.
r
give up?
k
There's another method for doing this, but I can't remember it offhand...
Hold on... wracking brain.
something about dense_rank
here's a similar formula.
MAX({transaction.rate}) KEEP(dense_rank last order by {transaction.trandate}, {transaction.trandate})