disctinct on textbox and distinct on table box

[davinfrost]

hi fellas,

i have a problem to discuss, so when i tried to disctinct a field which is [total so no]

the left one is im using Count(DISTINCT([Total SO No]))

and on the right one also same , im using Count(DISTINCT([Total SO No]))

but there is a difference in total,

how to get same total amount? btw ,im using same formula.

thanks

[sergio0592]

Hi,

You have a dimension in your chart on left. So in your text box, try with :

=sum(aggr(sum(distinct([Total So No]),Dimension))

[sergio0592]

Sorry, i forgot a (

=sum(aggr(sum(distinct([Total So No])),Dimension))

[davinfrost]

sorry mate, i wrote wrong codes,

Count(DISTINCT([Total SO No]))

i wanted to get total count of row from [Total so no]

[sergio0592]

So, try

=sum(aggr(count(distinct([Total So No])),Dimension))

[davinfrost]

i use this & ' Total Invoice = '&Count(aggr(DISTINCT([Total SO No]),[Total SO No])) it still same

i dont using sum because i only want to count

[davinfrost]

anyone help please??

[ArMehr · Accepted solution]

Hi, You can change type of total calculation in straight table:

Regular Sum (add every row toghether): 

expression total (calculate expression for total dimensions):

[avinashelite]

Hi 

I have you enabled the suppress null values in the chart ? if yes then un-check the same and compare your counts with the text box numbers it should match because text box considers null values in the dimension by default and in the chart you could eliminate it using suppress nulls 

[davinfrost]

this one really helps !!!

thank you so much mate !!