Sorry i mistankenly sent this to the "tools administration and installation" list... i deleted it from there and re-post here...


Hi,

I have a report script that shows totals per group, basically something like this:

tdsls040.crep|tiitm001.ccde|tdsls045.amnt|tdsls045.copr(1)*tdsls045.dqua

in the report i have totals per amnt and copr(1)*dqua after every crep and every ccde.
now i need to show tdsls045.amnt/(tdsls045.copr(1)*tdsls045.dqua)

but in the totals if i use the aggregate function named "total" i got a sum of tdsls045.amnt/(tdsls045.copr(1)*tdsls045.dqua) and if i use "average" i will get the average of that expression but what i need is something like this:

total(tdsls045.amnt)/total(tdsls045.copr(1)*tdsls045.dqua)

i'm trying to avoid do the sum manually because the script will become more complex, so the question is: is there any way to get the value of a grouped column to be used in another field (in the same line, of course)?

i hope my explanation was clear enough... :)

suggestions?

regards,
Jaime Casanova

I don't think this is possible just by an expression on the report field. I have in the past often programmed such things in the report script...