Oma -
It works the same way here on 1.862. My guess is that the FORMAT
function converts the value to TEXT which of course can't be summed. I ran
into this a long time ago and my work around was to do the original SELECT
without the sums; write the dashed lines; then do another select to get the
sums with the headers turned off.
Bernie
At 10:13 AM 12/15/2002 -0600, you wrote:
>
>Would Someone please check this out!
>
>Verify what I've done is correct!
>
>Problem:
>
>
>using format in an expression included in a Select statement it eliminates
>the =S feature (doesn't sum)
>Verified on the ConComp Database
>
>Version 1.862xRT03 Windows
>
>
>Example:
>
>select Model,sum(Units)=S,sum(extprice)=S from TransDetail group by model
>Model sum (Units sum (extprice)
> -------- ---------- ---------------
> CX3000 198 $319,900.00
> CX3010 50 $95,550.00
> CX3020 56 $89,275.00
> MB3030 135 $284,750.00
> MX3020 51 $89,500.00
> MX3030 10 $22,500.00
> PB3050 159 $368,000.00
> PX3040 170 $399,250.00
> -------- ---------- ---------------
> 829 $1,668,725.00
>
>select Model,(format(sum(Units),'9,999.00'))=S,sum(extprice)=S from
>TransDetail group by model
>
> Model (format(sum(Uni sum (extprice)
> -------- --------------- ---------------
> CX3000 198.00 $319,900.00
> CX3010 50.00 $95,550.00
> CX3020 56.00 $89,275.00
> MB3030 135.00 $284,750.00
> MX3020 51.00 $89,500.00
> MX3030 10.00 $22,500.00
> PB3050 159.00 $368,000.00
> PX3040 170.00 $399,250.00
> -------- --------------- ---------------
> $1,668,725.00
>
>
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: INTRO rbase-l
>================================================
>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: UNSUBSCRIBE rbase-l
>================================================
>TO SEARCH ARCHIVES:
>http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
