After waiting for 25 minutes on hold with support I was then told that "Formulas are beyond the scope of support and that I would need to contact Professional Services" :mad:
So I hung up.
Hopefully someone here can help me with this.
I have created a custom record saved search with the following criteria:
[LIST]
[*]Internal ID = 8901 (I'm doing this so I can work with just a single record during development)
[*]System Notes : New Value startswith 'Foo'[/LIST]Now this particular record has multiple System Note records where the specific field has changed to 'Foo' and this is completely normal. What I want to do is return the most recent "System Notes : New Value" data.
After reading some of the UG threads it seems that I need to do this with a formula field and use the dense_rank function. I've tried this but I'm getting an Unexpected Error.
Here are my results:
[LIST]
[*]ID | Group
[*]Formula (Text) | Group | max( {systemnotes.newvalue} ) keep( dense_rank last order by {systemnotes.date} )[/LIST]Does anyone have any idea where I'm going wrong? As you can see it's a pretty simple search.
Thanks for any help.