I have a requirement whereby if a selection is made within the fields of a specific table in the QV Data Model, one expression is used, else another expression is used.
I could do something like this: if(getselectedcount(salesrep)>0,sum(detail),sum(summary))
But the problem is I have a few dozen fields that must use an alternative expression with this same logic.
I do not want to have to list these fields out within nested if statement or whatever, because that will require maintenance. Is there a way to reference all the fields in a particular table in the data model so if(getselectedcount(all fields in customer table)>0,sum(detail),sum(summary)) that would be way better.