Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
Charlie Chaplin 2017

# Formula limitation

We cannot do calculation in step # 3 in Salesforce due to its limitation of handling very large numbers.

 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
satya arya
Hello Charlie Chaplin,

​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