Partial Sum not correct

[kaylaramsey2]

Hello,

My partial sum is not correct.  See screenshot below...

My issue is with the Duplicates column.  If you add up 5+2+3 you get 10 but my partial sum says 13. 

I have also attached my code.  Any thoughts?

[vamsee]

Hey Kayla, your attachment is missing. Can you please reattach your QVW

[kaylaramsey2]

I can only provide you with the expression code.  I can not share client data.

[Frank_Hartmann]

can u share a pic of the full expanded table?

[kaylaramsey2]

I am only looking at one patient here.  The fully expanded view would just show you the one patientID for each LabNM.  The Result column is just a count of a specific flag.  The partial sum the Result column shows is the correct number.  My issue is with the Duplicates partial sum

[Frank_Hartmann]

can you scramble the sensitive data and upload the qvw?

for scrambling go to settings --> document settings --> scrambling and choose the fields with sensitive data to

scramble. then save the document and upload the qvw!

[pooja_prabhu_n · Accepted solution]

Hi,

Partial Sum is considering expression total.

hence Duplicate=Total Result-1

                          =14-1

                          =13

You are getting 13 as Duplicate partial sum.

If you are using Straight table you can change the expression total to sum of Rows.

In pivot table you can use below expression.

=Sum( Aggr( Sum(Result)-1,LabNM))

Please find the attached qvw file for your reference

Thanks,

Pooja