This Formula Field (type: Number-18, 0) causes a "Number Too Large" error when I add it as a column to a Hyperforce org's Report--but it works fine
- in a Page Layout or
- in a non-Hyperforce org's Report.
Anyone got any ideas?
FIND(MID(Id, 15, 1), "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789") * 100000000
4 answers
Hello @Keiji Otsubo--thanks for the response!
I don't think that's the problem because if I increase the number of zeroes in my formula, it starts working again.
In the formula above I multiply
- the result of a FIND() function--which is a number between 1 and 62,
and
- 100,000,000.
. . . as you can see, that result should be, at most, a ten-digit number--nowhere near the 18-digit limit for my formula field. weird!
(I contacted Salesforce Support, they 1. replicated the error, and 2. said they didn't know what was causing it.)
any other suggestions are welcome!
