Use vLookup column to perform math on two other vLookup columns

[Chris Diltz]

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.

[Alexander Bautz]

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

[Author]

Posts