This content has been marked as final.
Show 5 replies

Re: Exclude current row dimension from TOTAL expression in a table
youssef belloum Mar 8, 2018 11:19 AM (in response to Jason Hendrickson)Hi,
can you add more details about the expected output ? like a screen shot of your table ? of your data structure ?


Re: Exclude current row dimension from TOTAL expression in a table
youssef belloum Mar 8, 2018 12:00 PM (in response to Jason Hendrickson)Can you share the source file ? or at least some rows ?

Re: Exclude current row dimension from TOTAL expression in a table
Jason Hendrickson Mar 8, 2018 12:25 PM (in response to youssef belloum)The employee data is confidential and cannot be shared. I have attached a blinded basic application.

employeeCompare.qvf 176.0 K





Re: Exclude current row dimension from TOTAL expression in a table
Jason Hendrickson Mar 15, 2018 12:09 PM (in response to Jason Hendrickson)I have found a solution. Much simpler than I expected. I was overthinking it as usual.
To calculate the sum of all rows other than the current row, subtract the current row sum from the TOTAL sum.
So for my question as example:
(SUM(TOTAL Numerator)  SUM(Numerator)) / (SUM(TOTAL Denominator)  SUM() Denominator)
This will give the aggregated compliance rate of all employees other than the current row employee.