Column SUM not working in Straight Table

[#1]

Hi Guys,

I have attached sample QVW file.

I am using simple sum formula like below  [Material Cost] + [Delivery Cost] to get the Total Cost Column.

But the the total Cost Column is only showing total when both fields have value.

As shown in below.. Order ID 2,3,5 & 6 does not show total cost.

If Delivery Cost column does not have any value then I still want the Total Cost column to show total.

How to achieve that ?

Thanks

[tamilarasu · Accepted solution]

Hi Lokesh,

Try this,

RangeSum(MaterialCost , DeliveryCost)

[#3]

Thanks