4 Replies Latest reply on Jul 7, 2016 12:28 PM by Sunyang Fu

    How to Select the Unique Row for Table Calculation

    Sunyang Fu

      I want to do a table calculation on the following table to calculate the UNIQUE sum of the column 'Amount'. The uniqueness is defined by the Hospital Name, Date and Amount. In the example below, I want to calculate the sum(Amount) filtered as the highlighted green. If the row is not uniquely defined by Hospital Name, Date and Amount, will be treated as duplicated value, and will not be added to the calculation. Could anyone help me with that? Thanks!

      2016-06-30 09_03_58-HRISE-PRD-ETL01.healthrise-aws.local - Remote Desktop Connection (hrise-rdgw-01..png

      In this case, the result should be: 4520+3025+5710+3465+...+3635