Column SUM not working in Straight Table

Thu, 25 Aug 2016 05:39:06 GMT

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

Re: Column SUM not working in Straight Table

tamilarasu — Thu, 25 Aug 2016 05:41:31 GMT

Hi Lokesh,

Try this,

RangeSum(MaterialCost , DeliveryCost)

Thu, 25 Aug 2016 05:45:20 GMT

Thanks