# #format Big Number#macro (Util_formatbignumber $bigNumber) #set ($intBigNumber = $mathTool. Tonumber ($bigNumber)) # if (! $intBigNumber) #set ($intBigNumber = 0) #end # if ($intBigNumber >= 10000 && $intBigNumber<100000000) #set ($value= $mathTool. Div ($intBigNumber,10000)) $numberTool. Format (' #0.0 ', $value) million # # #elseif ($intBigNumber>= 100000000) #set ($value = $mathTool. Div ($intBigNumber, 100000000)) $numberTool. Format (' #0.0 ', $value) billion #else$ intbignumber## #end #end# #format big money, like 1,000#macro (Util_formatbigmoney $bigNumber) #set ($intBigNumber = $mathTool. Tonumber ($bigNumber)) #if (! $intBigNumber) #set ($intBigNumber = 0) #end # if ($intBigNumber >= 1000) $ Numbertool.format (' #0, $intBigNumber) #else $intBigNumber # # #end #end
JS Processing
functionFormatenumber (value) {varnum =parseint (value); if(NUM >= 10000 && num < 100000000) { varSnum = (num/10000). toFixed (1); //alert (snum); returnSnum + ' million '; } Else if(Num >= 100000000) { varSnum = (num/100000000). toFixed (1); returnSnum + ' billion '; } Else { returnnum; }};/*Adjust number format, 100000 to 100,000*/functionFormatmoney (s) {s= Parsefloat ((s + ""). Replace (/[^\d\.-]/g, ""). ToFixed (0) + ""; varL = S.split (".") [0].split (""). Reverse (), T= ""; for(i = 0; i < l.length; i++) {T+ = L[i] + ((i + 1)% 3 = = 0 && (i + 1)! = L.length? "," : ""); } returnT.split (""). Reverse (). Join ("");}
About processing Money data JS and VMS