I have 2 analytes out of a large list that I would like to sum. I can get it to work with only one compound group for the compound math parameter. I am using multiple compound groups already for data review and reporting. The compound math doesn't work when I give it multiple compound groups.
this works, calculates my total:
But this does not:
I need the total to report in multiple groupings. But the "Z" group is only applied to the individual parameters I need summed.
I don't really want to add the sum to my reports, they work and are used to transfer to my LIMs so updating can be cumbersome.
Is there a way to make the compound math work and have it in multiple compound groups for reporting purposes?