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;
}
