Multiply columns MS SQL

Goran Bibic

8y1.1kSQL

Query is ok

In table mp_racun_roba (down in query) i have column name kolicina

1) I need to multiply this three column with kolicina

2) In sum column if have value with thousand separator not sum (example 1,644.00) just jump that value

SELECT SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,iznos_bpdv),1), '#,0.00','')AS decimal(10,2)),0.00)) as UKUPNObpdv,
SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,pdv),1), '#,0.00','')AS decimal(10,2)),0.00)) as UKUPNOpdv,
SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,iznos_sa_pdv),1), '#,0.00','')AS decimal(10,2)),0.00)) as UKUPNOsapdv
from mp_racun_roba
where tip_robe='Roba (Generalno)' and id_fakture='34'

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
Accepted answer
hi try
below
SELECT SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,iznos_bpdv),1), '#,0.00','')AS decimal(10,2)),0.00)) * SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,kolicina),1), '#,0.00','')AS decimal(10,2)),0.00)) as UKUPNObpdv,
SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,pdv),1), '#,0.00','')AS decimal(10,2)),0.00))*SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,kolicina),1), '#,0.00','')AS decimal(10,2)),0.00)) as UKUPNOpdv,
SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,iznos_sa_pdv),1), '#,0.00','')AS decimal(10,2)),0.00))*SUM(isnull(cast(REPLACE(TRY_CONVERT(float,TRY_CONVERT(float,kolicina),1), '#,0.00','')AS decimal(10,2)),0.00)) as UKUPNOsapdv
from mp_racun_roba
where tip_robe='Roba (Generalno)' and id_fakture='34'
Goran Bibic8y ago
It work Thank you

Rafnas T P
Goran Bibic8y ago
Detail for what? I need multiplication this three column wiht column quantity
Packiaraj Santhiyagu8y ago
Hi,

Can you give more detailes like your input and expected output?