You can use a calculated formula like this if the data source is an extract:
len([Comment]) - len(replace([Comment], "|", "")) + 1
Or this if not an extract:
len(ATTR([Comment])) - len(replace(ATTR([Comment]), "|", "")) + 1
I don't know why it is necessary with ATTR for non-extracts.
Hopefully this is a bug that will be fixed in near future.
Workbook is attached with a simple example.
Thanks, this worked. I appreciate the speedy reply.
So I understand the logic, you're removing the pipes then comparing the lengths of comment to compare new vs old?
This calculation would also work fine in SQL Server with some minor corrections. I mention this in case your source isn't an extract and that it is an issue that the calculation is a measure (not dimension). Said differently, if you need the calculation without the ATTR function.