Re: Problems with views and SUM
From: Roya Mehrfar <roya_mehrfar_at_qmbridge.calstate.edu>
Date: 1996/07/05
Message-ID: <31DCFB9A.6144_at_qmbridge.calstate.edu>#1/1
Date: 1996/07/05
Message-ID: <31DCFB9A.6144_at_qmbridge.calstate.edu>#1/1
Fred,
It sounds like your display column is not large enough to display the
decimal points. Try the format statement to display all of it.
Use the syntax below:
COLUMN SUM_DEBIT FORMAT 999999999.99
where you should use an alias for the sum(debit) in your select
statement:
select exer, sum(debit) sum_debit
from ....
Roya Received on Fri Jul 05 1996 - 00:00:00 CEST