OVERFLOW BECAUSE of CHARACTER LENGTH

Hi I'm having an error because of the character length of my "Account Number" that will be the basis need to get the highest/latest "Service End Date" every row. Here's my formula:
=MAX(COLLECT([Service End Date]:[Service End Date], [Account Number]:[Account Number], [Account Number]@row))
Best Answer
-
Hi @JonahD.
Is it possible / worth while creating a helper Account Number column that uses =RIGHT([Account Number], 5) for the last 5 digits (or how ever many numbers up to 12) of the Account Number?
Your formula could then reference the helper column instead.
Thoughts?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Answers
-
Hi @JonahD.
Is it possible / worth while creating a helper Account Number column that uses =RIGHT([Account Number], 5) for the last 5 digits (or how ever many numbers up to 12) of the Account Number?
Your formula could then reference the helper column instead.
Thoughts?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives