problem with sum and %

[ScanX]

hello

I would like to calculate a percentage in a column depending on the results of the 2 other column..very trivial I know but still causing some trouble.

I'm new to Sybase so please be indulgent

SELECT
rtrim(DBA.agg_duplic_source.source),
sum(DBA.agg_duplic_source.nbr_household_unique),
sum(DBA.agg_duplic_source.nbr_household_duplicated),
(sum(DBA.agg_duplic_source.nbr_household_unique)) / ((sum(DBA.agg_duplic_source.nbr_household_unique)) +
(sum(DBA.agg_duplic_source.nbr_household_duplicated))),

 

[ScanX]

nevermind I found it, just needed to cast stuff