Sum Total with Set modifier Distinct Field

[akuttler]

Hello I am trying to sum total encounter charges for distinct ENCID's.

I tired the expression below but it gives me 0.00

Sum({<ENCID={'Distinct ENCID'}>}[ENCID Total Charges])

Thanks in advance.

[Thiago_Justen_]

Try this:

Sum (Aggr (Sum([ENCID Total Charges]), ENCID))

[sunny_talwar · Accepted solution]

Did you forget to add DISTINCT?

Sum (Aggr (Sum(DISTINCT [ENCID Total Charges]), ENCID))

[Thiago_Justen_]

My fault stalwar1‌. You're right!

[akuttler]

Thank you! It works.