Tomas Toth
12th August 2011, 12:04
I do not know how to specify an SQL when I need to summarize fields "tdinv760.aupp(1)" till "tdinv760.aupp(12)" into one field ?
Don't you know what may be the meaning of "tdinv760.aupp(13)" ?

bdittmar
12th August 2011, 15:55
I do not know how to specify an SQL when I need to summarize fields "tdinv760.aupp(1)" till "tdinv760.aupp(12)" into one field ?
Don't you know what may be the meaning of "tdinv760.aupp(13)" ?

Hello,

tdinv760.aupp(13) ist a correction period.
In most cases not used (filled)
Field tdinv760 is a double array.

Simple way, define a variable like :


extern domain tcmcs.double take.summery


in selectdo

take.summery = tdinv760.aupp(1) + ....... tdinv760.aupp(13)


Regards