Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be use RanguSum(Column1, Column2)
Or you should show data and expected result
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
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.
In the table
sum( rangesum(VAr1,Var2)
or In the script
rangesum(VAr1,Var2) as #nameSumVAr
and then in Table
sum(#nameSumVAr)
Gruß gerold
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.
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')