topic Re: using sum in Application Development and Automation Discussions

using sum

Former Member — Wed, 07 Mar 2007 05:06:24 GMT

hi ,

if i have two or more numeric type fields in my table and i am using the

SUM to give me a grand total of only one field(column). Does the sum calculate

the sum of the field i wanted or all the fields with numeric datatypes present

in the table.

Former Member — Wed, 07 Mar 2007 05:08:50 GMT

Hi,

Yes..It will sum up all the numeric fields..

Thanks,

Naren

Former Member — Wed, 07 Mar 2007 05:11:57 GMT

Hi vijay..

It will sum up all the numeric fields.........

u should be care full when you are using <b>sum</b> because the sum of the values in any field may cause an overflow and it may go for a dump.....

Suresh....

Former Member — Wed, 07 Mar 2007 05:18:07 GMT

Hi ,

it will sum up all the field of type I , P , N.

Former Member — Wed, 07 Mar 2007 12:34:02 GMT

It will sum up values of fields with domain data type N, I, P.

Pulokesh