Sum of positive numbers only

[veles]

Hi,

I am using Crystal XI

I have a field that contains positive and negative numbers.

I need a formula to sum only the positive numbers

Example
3
4
-2
Sum to show 7 instead of 5

Thanks

 

[lbass]

Create a formula like this:

if {table.number} > 0 then
{table.number}

Place this in the detail section and right click on it and insert a sum on it.

-LB

 

[veles]

Thanks LB. I will try this and report back. Your solutions always work for me

 

[veles]

LB it works perfectly.

Thanks once again