Use vLookup column to perform math on two other vLookup columns › Forums › vLooup for SharePoint › Use vLookup column to perform math on two other vLookup columns This topic contains 1 reply, has 2 voices, and was last updated by Alexander Bautz 1 year, 4 months ago. Author Posts December 22, 2016 at 16:51 #14646 Chris DiltzParticipant I have two vLookup columns that return a count based on their respective queries. How can I use a new vLookup column to divide the two values to give me a percentage? Use case: for reporting via a list view, show total number of test cases for parent item, show number of test cases that are complete, show the complete percentage for the parent item. Let me know if I’m overthinking this but I’ve looked through the forums and user guide and can’t find the answer. I imagine the new vLookup will need to call a custom function. December 28, 2016 at 20:06 #14685 Alexander BautzKeymaster Hi, If you want this to run “live” in a list view it may be a bit “heavy”, but if you can set up the calculation in the form where you add the vLookup children you can use a bit of custom code – something like this http://spjsblog.com/forums/topic/sum-action-in-vlookups/ or using the “vLookup dato object” like this: http://spjsblog.com/forums/topic/sum-multiple-vlookup-total-columns/ Alexander Author Posts You must be logged in to reply to this topic.