Exclude numbers from and expression

[Anonymous]

I am creating a line chart and in one of my expressions (Orders)  I am trying to sum up the orders but when I did

=Sum(Orders)     I noticed that there is a spike in the numbers.  I am wanting to exclude all the numbers in Orders that caused the spike and not used them in this line.  So I tried to do something like this

=if(Orders <5000,sum(Orders))   but my line just went away then.

Is there anything I can do to sum up the orders but keep anything over 5000 out?

[swuehl · Accepted solution]

=sum(if(Orders <5000,Orders))

Conditional Aggregations