Expression to sum only positive amounts

[#1]

I have a column in a straight table with positive and negative monetary amounts.  I want to sum only the positive amounts and exclude the negative amounts from the total.  Do you know the proper expression to use? 

[tresesco]

From the total of the same straight table column?

[#3]

correct. thanks

[anbu1984]

Try this

=if(rowno()=0 or isNull(rowno())

  ,Sum(If(Sales>0,Sales))

  ,Sum(Sales)

)

[tresesco]

May be like attached sample.

=If( RowNo()=0 or IsNull(RowNo()), Sum(Aggr(If(Sum(amt)>0,Sum(amt)),Listvalue)), Sum(amt))

[tresesco]

Anbu, your solution works on individual member of Sales not on aggregated amount, so it gives a different result.

[#7]

do you want to display -ve number in that column if not you can convert -ve number into zero by using if condition and you will get the sum of only positive numbers

=if(sum(amt)<0,0,sum(amt))

and to show all dimensions you can uncheck option suppress zero value in chart properties presentation tab

-Rajendra

[Anonymous]

Hello, Erica.

I would try this expression:

if(Dimensionality() = 0, Sum(if(Value > 0, Value)), Sum(Value))

Dimensionality() equal 0 when it's the total row.

Regards.