Subject | Percentage Calculation? |
---|---|
Author | googlepost123 |
Post date | 2005-08-07T19:25:13Z |
Hi,
Is there a way in FB SQL to calculate a percentage column line
Custid, Sum(Sales-Cost)/Sum(Sales) AS GM%
so that gm% would be returned as %##0.000 or will this have to be
handled by the calling program?
TIA
Dan
Is there a way in FB SQL to calculate a percentage column line
Custid, Sum(Sales-Cost)/Sum(Sales) AS GM%
so that gm% would be returned as %##0.000 or will this have to be
handled by the calling program?
TIA
Dan