Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Try this
=Replace(Replace(FinalMessage1, 'Date1', Max(TOTAL {<MeasureID>} EVENT_DATE)), 'Date2', Max(TOTAL {<MeasureID>} DUE_DATE))
Try this
=Replace(Replace(FinalMessage1, 'Date1', Max(TOTAL {<MeasureID>} EVENT_DATE)), 'Date2', Max(TOTAL {<MeasureID>} DUE_DATE))
Thank you!!!