Sum doesn't work in Straight Table

[anuradhaa]

I'm using view to load data.

it has two colums in number data type.

After load the data i use above two columns to add them together in expression. but some records were not available in the grid.

ex- when id = 120, both columns has ' 0 ' data that records is not available.

[Anil_Babu_Samineni]

May be use RanguSum(Column1, Column2)

Or you should show data and expected result

[anuradhaa]

I found the issue,

I use Val1 + Val 2 in my expression,

use if((Val1 + Val 2)>0,(Val1 + Val 2),'0.00').

but when i use this, that raw doesn't show.

but use if((Val1 + Val 2)>0,(Val1 + Val 2),'www').

it shows 'www' when val1 and val2 is 0.

Val1 + Val 2 also don't show any record

[jonathandienst]

Not sure if I understand your issue, but I think what you need is this expression:

=RangeMax(RangeSum(Val1, Val2), 0)

The RangeSum ensures that a null value in either field does not result in a null result. The RangeMax replaces your If() and returns only the positive values.

[gerry_hdm]

In the table

sum( rangesum(VAr1,Var2)

or In the script

rangesum(VAr1,Var2) as #nameSumVAr

and then in Table

sum(#nameSumVAr)

Gruß gerold

[Siva_Sankar]

Anuradha,

Not sure if i understand your issue correctly, if you are talking about total row at the bottom..check if you enabled Sum of Rows instead of Expression Total under the Expression tab.

[Anil_Babu_Samineni]

but use if((Val1 + Val 2)>0,(Val1 + Val 2),'www').

it shows 'www' when val1 and val2 is 0.

Because, Here you are taking only o above data. If you want to calculate with 0 then expression should this

if((Val1 + Val 2)>=0,(Val1 + Val 2),'www')