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

Viewing 1 reply thread
  • 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 https://spjsblog.com/forums/topic/sum-action-in-vlookups/ or using the “vLookup dato object” like this: https://spjsblog.com/forums/topic/sum-multiple-vlookup-total-columns/

      Alexander

Viewing 1 reply thread
  • You must be logged in to reply to this topic.