Apex Code Development You need to sign in to do that
Don't have an account?
Formula limitation
We cannot do calculation in step # 3 in Salesforce due to its limitation of handling very large numbers.
Any help will be really appreciated
| Creating | Example | Chart | |||
| a | 10 | ||||
| System number | 10Bx939c5543TqA1144M | b | 11 | ||
| Account Number | 999143x | c | 12 | ||
| d | 13 | ||||
| Step 1 | Conversion using chart | 1011329391255432926101144229914333 | e | 14 | |
| f | 15 | ||||
| Step 2 | Add 00 at end | 101132939125543000000000000000000000 | g | 16 | |
| h | 17 | ||||
| Step 3 | Divide by 97 | 1042617929129312294946332267952920.618556701030928 | i | 18 | |
| Truncate the remainder to 3 digits | .618 | j | 19 | ||
| Multiply by 97 | 59.946 | k | 20 | ||
| Round to the nearest whole number | 60 | l | 21 | ||
| m | 22 | ||||
| n | 23 | ||||
| o | 24 | ||||
| p | 25 | ||||
| q | 26 | ||||
| r | 27 | ||||
| s | 28 | ||||
| t | 29 | ||||
| u | 30 | ||||
| v | 31 | ||||
| w | 32 | ||||
| x | 33 | ||||
| y | 34 | ||||
| z | 35 | ||||
Any help will be really appreciated
One solution is - Use text field and create a function which will read that text string (actually very large number) and will do calculation for you.
Thanks
Satya