Reply To: Sum action in vLookups

Forums vLooup for SharePoint Sum action in vLookups Reply To: Sum action in vLookups

#9757
avala
Participant

No worries. I appreciate you taking the time to answer our little questions.

This is the code I’m currently using (I’ve commented out the rest until I can get the Subtotal working). I’ve grabbed the field internal name from the child list for Line Total (Line_x0020_Total) and used the field internal name for the vLookup (vLookup) field in the parent. Is this correct? When the function is triggered it empties the Subtotal field.


fields = init_fields_v2();

function CalcTotal()
{

var vLookupTotal = $(".vLookup_Line_x0020_Total_vLookup").text();
//var Subtotal = getFieldValue('Subtotal');
//var Tax = getFieldValue('Sales_x0020_Tax');
//var Prod = ((Subtotal*Tax)/100);
//var TotalCalc = (+Prod + +Subtotal);

setFieldValue('Subtotal',vLookupTotal);
//setFieldValue('Total',TotalCalc);
}