Board index » jbuilder » Using calculated Columns

Using calculated Columns


2003-11-29 03:19:48 AM
jbuilder22
Hi,
I am using aggregated columns to sum the cost and selling prices,
respectfully, however i would like to the run a calculation of these two
values to return the outstanding balance. But when i do so i get a value of
0 returned. Is this because the calucation get carried out before the
summation??
Thanks
Rudy
 
 

Re:Using calculated Columns

"Rudy" < XXXX@XXXXX.COM >wrote in
Quote
I am using aggregated columns to sum the cost and selling prices,
respectfully,
You could add an aggregated column that sums the selling price-cost.
--
Iman
 

Re:Using calculated Columns

Yeah true, thanks for that...silly me
Rudy
"Iman L Crawford" <ilcrawford.at.hotmail.dot.com>wrote in message
Quote
"Rudy" < XXXX@XXXXX.COM >wrote in
news: XXXX@XXXXX.COM :
>I am using aggregated columns to sum the cost and selling prices,
>respectfully,

You could add an aggregated column that sums the selling price-cost.

--
Iman


 

{smallsort}

Re:Using calculated Columns

Actually the agg descriptor does not allow this
Rudy
"Iman L Crawford" <ilcrawford.at.hotmail.dot.com>wrote in message
Quote
"Rudy" < XXXX@XXXXX.COM >wrote in
news: XXXX@XXXXX.COM :
>I am using aggregated columns to sum the cost and selling prices,
>respectfully,

You could add an aggregated column that sums the selling price-cost.

--
Iman


 

Re:Using calculated Columns

"Rudy" < XXXX@XXXXX.COM >wrote in
Quote
Actually the agg descriptor does not allow this
Rudy
My apologies, you might try writing a custom aggregator.
--
Iman