I have this SQL:

select field1, sum(field2*field3) "Newfield1", sum(field2+field3)
"Newfield2"
from ....
group by field1

How do I also get included in the output newfield1/newfield2*100 as another
field ? And even better casted as an integer.

DBISAM 3.30

Regards
Uffe

Uffe


I'm not sure you can in V3, but in V4

select _boxtype, sum(_boxno * _belongsto) "Newfield1", sum(_boxno + _belongsto) "Newfield2",
CAST ((sum(_boxno * _belongsto) / sum((_boxno + _belongsto) * 100)) AS INTEGER) "Newfield3"
from banda
group by _boxtype;

works. If it doesn't for you try a script, do your first select into a memory table and then work on the fields from there


Roy Lambert

"Uffe Kousgaard" <oh@no.no> wrote in message
news:F8222136-CF4B-4A00-BFD2-43B00DE233B3@news.elevatesoft.com...
>I have this SQL:
>
> select field1, sum(field2*field3) "Newfield1", sum(field2+field3)
> "Newfield2"
> from ....
> group by field1
>
> How do I also get included in the output newfield1/newfield2*100 as
> another field ? And even better casted as an integer.
>
> DBISAM 3.30
>

I think if you use parenthesis to indicate the sequence of operations

SUM (((Field2*Field3) / (Field4 + Field5)) * 100)

should give you the result you want. You can wrap the whole thing in a
"cast" if necessary.

Robert

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:34F5B608-FF89-458B-8B6A-AA01CF1925FB@news.elevatesoft.com...
>
> works. If it doesn't for you try a script, do your first select into a
> memory table and then work on the fields from there

Thanks, that's what I ended up doing.