calculating straight table total

[engr_farhanqadr]

Dear Folks,

I have designed a straight table in which I have column Total Values

where i have sum up different columns which are WH value , In Transit value and Fba Stock value by adding their expression labels but the values are not shown at respective rows and total at header is also wrong.

please correct me where I am wrong.

Attached is the file.

Regards,

Farhan.

[#2]

Use the below to calculate Total Value.

=Alt([WH Value],0)+Alt([In Transit Value],0)+Alt([FBA Stock Value],0)

[maxgro]

=rangesum([WH Value],[In Transit Value],[FBA Stock Value])

from online help

rangesum(expr1 [ , expr2, ... exprN ])

Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0.

[engr_farhanqadr]

Thanks srukmana.