hi have a prob

whene im trying to count my data im getting the row count

for exmp:
i have 3 row

row 1 eq to 20
row 2 eq to 10
row 3 eq to 1

my resaolt is 3 becuse i have 3 row
and i want the resault to be 31 that is the sum of the data

This message has been edited. Last edited by: Kerry,

I've either missed something completely or you really must get some absolutely basic training.

If you simply want a sum:

SUM <column name>

If you want counts and sums:

SUM CNT.<column name>

or

COUNT SUM.<column name>

WHEN I DO SUM
I GET THE RESAULT OF HOW MANY ROW I HAVE

BUT WHAT I NEED IS TO COUNT THE DATA INSIDE THE ROW

would you be so kind to post the code of your fex

You are very unclear about what you are trying to do.

As Dan said if you do SUM column name against a data source it will give you a sum of the data values
if the column is numeric. If the column is alpha it will give you the last value.

COUNT or CNT. will give you a count of the column based on any sort you have.

My suspicion however is that you are trying to count the elements of an array which is a totally different thing.

An example of your data and the associated master might shed more light on what you are actually trying to do.