Using text mode to concatenate custom rich text field in a report? getting error message

[user01245]

I have a custom rich text field called /Request notes'. I want to include it in a report, but concatenate it so only the first 200 characters are shown.  When I try to do this by using text mode and replacing 'valueifled' with 'valuexpression' like I do with other fields I get an error message when loading the report.  Do I have to do something different because this is a rich text field?

Here's what I've tried that results in an error:

valueexpression=IF(LEN({Request notes})>150,CONCAT(LEFT({Request notes},150)," (cont...)"),{Request notes})
valueformat=customDataRichTextAsString
linkedname=direct
namekey=Request notes
tile.name=component.customdata.richtextlistview
type=tile

Thank you in advance for your help!

[Rafal_Bainie · Accepted solution]

I believe you cannot use rich text fields in expressions. To verify this, try this formula in calculated field in Custom Forms section. I'm pretty sure this formula won't work there either.

[KellieGardner]

@user01245 - Rafal is correct. Rich Text Fields cannot be used in calculations or text mode because of how they are stored. They are also very difficult to use in Fusion. I usually recommend systems not use the RTF if they are going to be doing any type of expanded reporting or integrations.

There's an idea out there you can upvote Ability to use rich text format fields in Calculat... - Adobe Experience League Community - 529845