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 8 months, 4 weeks ago.

  • Author
    Posts
  • #14646

    Chris Diltz
    Participant

    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.

  • #14685

    Alexander Bautz
    Keymaster

    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

You must be logged in to reply to this topic.