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