Count Of Field

[Anonymous]

Hi All

Need Help with this please.

Count(Distinct({<Field = {[0]}>}%Acct))

i want to Count %Acct but the field is [0]

Thanks Again!

[Chanty4u]

try this

SUM({<[field]=[0]>} %ACT))

[Anonymous]

Please see the New upload

And check expression, this is what i needed.

[sunny_talwar]

I still don't understand Count(Distinct(%Acct) for 0 will be equal to Count(Distinct %Acct)

What is the number that you are expecting to see here?

[Chanty4u · Accepted solution]

chk dis

[Anonymous]

I want to see how many accounts made up for month 0 and how many made up for month 1

In my data there is different data per month and month goes upto 72...HAHA

[sunny_talwar]

I have no idea what you are trying to do. Can you show some screenshots of your real data?

[Anonymous]

How can i make this static so it does not change please

=sum(aggr(count(distinct %OurRef),[0]))

so i guess  i have to add a 1 somewhere?

Thanks

[sunny_talwar]

For that you can do this:

=Sum({1}Aggr(Count({1}distinct %OurRef),[0]))

[Anonymous]

Thanks All for the Help

[Chanty4u]

cool.. u got the solution