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]

use simply

count(Distinct [Fieldname])

[Kushal_Chawda]

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

[sunny_talwar]

Kush today is your Aggr day

I am seeing Aggr() in all your proposed solutions

[Anonymous]

I have attached a Test Doc

I wanted a Count of Accounts for the Group

[Kushal_Chawda]

Yeah, feeling like to use Aggr. Not good but requirements seems like that

[Chanty4u]

Count({$<filed={'[0]'}>} DISTINCT %act)

[sunny_talwar]

I don't see any field names as [0]

[Anonymous]

Sorry  i wrote Month in Test Script

The Month should be 0 then same data for 1 then same data for 2 etc

[sunny_talwar]

Try this:

Sum({<Month = {0}>}Money)

[sunny_talwar]

Or may be a pivot table like this?

Month as second dimension here and Sum(Money) as the expression