Replace in Calculated Dimension

[byrnel0586]

Hi all,

I am attempting to replace some text in a field using a calculated dimension and am getting an error. I was doing this in the script previously, but there can be multiple EVENT_DATES and I only want to show the max of them in the message. The expression will work in a text object. I have also attached a screenshot.  Any help is appreciated!

=Replace(Replace(FinalMessage1,'Date1',max({<MeasureID>}EVENT_DATE)),'Date2',max({<MeasureID>}DUE_DATE))

[sunny_talwar · Accepted solution]

Try this

=Replace(Replace(FinalMessage1, 'Date1', Max(TOTAL {<MeasureID>} EVENT_DATE)), 'Date2', Max(TOTAL {<MeasureID>} DUE_DATE))

[byrnel0586]

Thank you!!!