sql - Error while sum a column report builder 3

Question

I am creating a report that sums an entire column into one. The formula I am using in report builder is =Sum(Fields!QTY.Value) but the result #Error. The cell is already formatted as number with no decimal places. The formula works well for a column formatted as currency.

The data from SQL displays the column as the quantity followed by .00000 maybe that is the issue?

Select distinct 
   bold.FGPART as Part,
   bold.FGQSHO as QTY,
   ocri.ddunpr*bold.fgqshp as Price    
FROM BOLH    
left join bold 
   on bolh.FEBOL# = bold.FGBOL# 
left join ocri 
   on bold.FGORD# = ocri.DDORD# 
   and bold.FGITEM = ocri.DDITM#    
where bolh.febol# = '763490'


   Part                   QTY           Price
KA183 2-012             54.00000    1.7280000000
KA183 2-212             24.00000    3480.0000000000
KA183 2-221             24.00000    8.6400000000
KA183 2-224             24.00000    10.6560000000
KA183 2-341             16.00000    19.2480000000
                          #Error       $3520.27

Answer 1

等待大神答复