sum a number with a condition

[#1]

this i tha table that i have

area1	number
A	100
A	100
B	50
C	100
D	500
D	400

what i need i very simple

i need  2 text boxex

1. sum all numbers of all areas (this i have)=1250

2. sum all numbers except D- the result should be=350 -this i need

[arulsettu · Accepted solution]

try this

sum({<area1-={'D'}>}number)

[sunny_talwar]

Try these:

1) Sum(number)

2) Sum({<area1 -= {'D'}>}number) -> This would filter out area1 not selected (while still excluding D)

or

Sum({<area1 = {'*'} - {'D'}>}number) -> This would not change based on selection in area1

[Anonymous]

Hi

try this

1st text box ..>General..>Text...>

=sum(number)

2nd text box ..>General..>Text...>

=sum({$<area1=-{'D'}>} number)