Home › Forums › vLooup for SharePoint › Sum multiple vLookup Total columns › Reply To: Sum multiple vLookup Total columns
April 1, 2016 at 15:58
#10979
Thanks, Alexander. I cleaned up the code a little bit but I’m still not getting the vLookup event loaders to work. I’m able to get the functions running off a button click just fine. The entirety of my JS code is below along with our DFFS versions. If there’s anything I can test with DFFS let me know. If it’s code on our end I’ll keep researching.
fields = init_fields_v2(); function vLookupIsLoadedCallback(fin){ if(fin === "vLookup"){ CalcTotal(); } } function CalcTotal(){ var vLookupTotal = $(".vLookup_total_vLookup:eq(6)").text(); setFieldValue('Subtotal',vLookupTotal); var Subtotal = getFieldValue('Subtotal'); var Subtotalnew = parseFloat(Subtotal .replace(/[^0-9-.]/g, '')); var Tax = getFieldValue('Sales_x0020_Tax'); var Prod = ((Subtotalnew*Tax)/100); var TotalCalc = (Prod + Subtotalnew); var result = CurrencyFormatted(TotalCalc); result = CommaFormatted(result); setFieldValue('Total',"$" +result); } function CurrencyFormatted(amount) { var i = parseFloat(amount); if(isNaN(i)) { i = 0.00; } var minus = ''; if(i < 0) { minus = '-'; } i = Math.abs(i); i = parseInt((i + .005) * 100); i = i / 100; s = new String(i); if(s.indexOf('.') < 0) { s += '.00'; } if(s.indexOf('.') == (s.length - 2)) { s += '0'; } s = minus + s; return s; } function CommaFormatted(amount) { var delimiter = ","; // replace comma if desired var a = amount.split('.',2) var d = a[1]; var i = parseInt(a[0]); if(isNaN(i)) { return ''; } var minus = ''; if(i < 0) { minus = '-'; } i = Math.abs(i); var n = new String(i); var a = []; while(n.length > 3) { var nn = n.substr(n.length-3); a.unshift(nn); n = n.substr(0,n.length-3); } if(n.length > 0) { a.unshift(n); } n = a.join(delimiter); if(d.length < 1) { amount = n; } else { amount = n + '.' + d; } amount = minus + amount; return amount; }