topic Re: Exclude current row dimension from TOTAL expression in a table in App Development

Exclude current row dimension from TOTAL expression in a table

sashimisan77 — Thu, 08 Mar 2018 16:00:18 GMT

I am working on an application comparing performance of employees to a group of peers in a table. Each row is dimensioned by the employee and contains a compliance rate SUM(numerator)/SUM(denominator) and is being compared to SUM(TOTAL numerator)/SUM(TOTAL denominator). However, this compares the employee compliance rate to the group's compliance rate including the employee in the current row. I would like to compare the employee to the group excluding the employee in the current row.

Re: Exclude current row dimension from TOTAL expression in a table

YoussefBelloum — Thu, 08 Mar 2018 16:19:15 GMT

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

sashimisan77 — Thu, 08 Mar 2018 16:56:51 GMT

Re: Exclude current row dimension from TOTAL expression in a table

YoussefBelloum — Thu, 08 Mar 2018 17:00:42 GMT

Can you share the source file ? or at least some rows ?

Re: Exclude current row dimension from TOTAL expression in a table

sashimisan77 — Thu, 08 Mar 2018 17:25:31 GMT

The employee data is confidential and cannot be shared. I have attached a blinded basic application.

Re: Exclude current row dimension from TOTAL expression in a table

sashimisan77 — Thu, 15 Mar 2018 16:09:32 GMT

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.