Report Formula

Question

I have found posts on this, but they don't address what I'm looking for, which is a report formula.
I only want to see the last entry on a notes field that is already there and has multiple entries. I used the formulas in the posts I found, in the reports formula, and they didn't work.
I can't set up a new text formula field so I'm looking for anything that will work in a report formula.

Thank you

------------------------------
Steven Pearson
------------------------------

markshnier__you · Answer

If you are referring to a field with logging enabled, can you post an example of what's in the field?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

stevenpearson · Answer

Here is the field, most have multiple notes entered.------------------------------Steven Pearson------------------------------

markshnier__you · Answer

try thisvar text LogField = [My Log changes append only field at the top];If(Trim($logField)&lt;&gt;"", "[" &amp; Left(NotLeft($LogField,"["),"["))------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

stevenpearson · Answer

No luck. Still the same results as above.------------------------------Steven Pearson------------------------------

markshnier__you · Answer

Can you post your code for the report formula field?&nbsp; Did you put the Report formula field on the report?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Report Formula

7 Replies