count monthyear

[Anonymous]

hi,

i have feild monthyear.

i want to count it for calculte averege for sum(kg).

if i write count(monthyear) - the resolt is not good.

thamks'

yarin.

[MK_QSL · Accepted solution]

may be count(distinct monthyear)

if possible, provide sample data

[#3]

Hi Yarin

count(monthyear)  will count every record and display the number of records according to your selection

what do you need ?  may be a count(distinct monthyear)  ?

Chris