Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Need Help with this please.
Count(Distinct({<Field = {[0]}>}%Acct))
i want to Count %Acct but the field is [0]
Thanks Again!
chk dis
It shows the value as [0] or 0?
Count(DISTINCT {<Field = {0}>} [%Acct])
try this
Count(Distinct({<Field = {'0'}>}%Acct))
Sorry i think i confused you guys, I mean Count the Field
.......Name of field is [0]
So its Count Distinct %Acct where [0] in a straight Table
where [0] is available?
Count({<[0] = {'*'}>}[%Acct])
Where [0] is what??
= Count(Distinct {<field= {'value'}>}%act)
e.g
I have 10 fields
0 to 10
I am suming money
I want to know how much account this group has
So i have a new Expression sum the accounts per month
Sorry i want to just sum the field not add a value
May be you want to do a distinct count of the [0] field itself?
Count(DISTINCT [0])