Crystal Reports Formula fields SUM only positive values using WHERE

Question

Within my crystal report details section i have several values from the field amount, i added a simple formula field to my group header to calculate the SUM({Amount}) Which works however i only want it to SUM the positive values.

There is always a negative version of the positive.

Data

Current Output with SUM({Amount})

Desired Output

Something like but in crystal variant

SUM({Amount}) FROM mytable WHERE {Amount} > 0

Looks like a case statement might work stackoverflow.com/questions/13134230/… Perhaps soemthing like Sum(case when {amount}>0 then {amount} else 0 end) or forums.asp.net/t/… — xQbert

Ankur Alankar Biswal Ankur Alankar Biswal · Accepted Answer · 2015-07-01T14:36:32

You can use two formula to fulfill ur requrement

1.@Positive_Number

if{Table.amount} > 0 then {Table.amount} else 0

2.@Sum_of_PositiveNumber

Sum ({@positive_Number})

thanks Ankur

Crystal Reports Formula fields SUM only positive values using WHERE

3 Answers