Sum of distinct countif

Question & Answer
, ,
1

Hi,
How to get the total Accounts .
accounts formula is distinct_countIf(agent, isNotNull({agent}) AND transtype = ‘Sales’)

image

Thanks, Tin

2

Hi @ctine

Could you please provide a bit more detail as to what the data looks like?

thanks
Ramon

1 Like
3

HI @ctine Can you explain it more clearly because the total I see is 108 but you mention 118 so please shared your query once more time.

Thanks & Regards
Biswajit Dash

1 Like
4

Hi @ctine

We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.