Straight table won't calculate sum

[#1]

I have a report which won't produce the sums at top of the table. Previously, I had a lot of null values, so I went through my SQL script, and used

the coalesce function to turn most of them into zeros. However, some still came through. I used an "IF" statement to convert nulls to zeros, but

they came out as text, not numbers (I checked by exporting into Excel). So now my expressions look like this:

=num(if(isnull(EquipmentCreated),0,EquipmentCreated))

It still won't sum in my straight table, although if I export to Excel, it does work.

Why won't QV do this??

I have attached a couple of files.

Thanks!

[MayilVahanan · Accepted solution]

Hi

Please see the attached image.

Hope it helps

[#3]

It is because of the equation; it shows 'NULL', but you have set it to show '0' instead.  You can use Chart Properties > Expressions > Sum of Rows: