Thank you for the quick response. I can't seem to get this to work for me – I'm not sure if it is because neither of my field values are numerical and both are text strings?
As another possible workaround – is it possible to have a table display more than one value for a measured field? Using the above example, would it be possible to have:
and have the resulting table look like:
A Bob, Mark, Steve
B Bob, Mary
C Bob, Mark, Mary
Right now if I use the above settings, it only returns the first field value for each project and my result is:
Thanks for your help.
Thanks again for your help.
I used your solution to apply to various different KPIs and tables in the attached sheet, but I can't seem to get it to work for "Highest Redpoint Grade."
It works great when I have one or more "Partners" selected, but before I have selected any, the KPI is blank. I've tried many different permutations and can successfully get either the true or the false statement of the original if() to work if I use a simple string for the other, (true or false respectively). This makes me think it is something to do with the nested if()s.
I image my solution to getting the max grade isn't the most elegant, and if there is a better way I am always open to suggestions, but for now it is a pretty long list of nested if()s.
Thanks again in advance.
map and filter.qvf 7.0 MB