Sum Only Expression Help!

[#1]

Hi gang, i need your help. I need to sum only regional contracts. I have a listing of contracts, and some of them are tagged as "regional." How can i sum only regional contracts using an expression?

Vendor	Value	Contract Type
Ricks' Car	$10	Regional
Jim Auto	$55	Regional
J&J taxi	$5	Local

the answer would be $65 (Ricks and Jims total)

Regards,

Brian

[swuehl · Accepted solution]

Brian, you could use a sum(if()) for this

=sum( if([Contract Type] = 'Regional', Value))

or equivalent, but better performing a set expression

=sum( {<[Contract Type]={Regional}>} Value)

Just put this expression in a chart object, e.g. a text box.

Hope this helps,

Stefan