Count Distinct Exclude Total Row

[#1]

I have a chart with a total row.  When I execute the =count(distinct(field name)) the total includes the row with the totals.  Is there a way to eliminate the total row in the count?  Thanks.

[Anonymous]

Yes, suppress when null is checked

[#3]

When I created a sample app to share the count function worked as desired.

[avinashelite]

Cool , if you got the answer ..please mark the correct answer and close this thread so that will be helpful for others

[#5]

Unfortunately the problem still exists in my original app.

[PrashantSangle · Accepted solution]

Hi,

Because of it you are getting 1 extra count.

Either you can subtract 1 manually from your expression or handle null value dimension in your expression

Regards