Totaling Columns with "if" function

[#1]

I have two columns; one contains alpha data the other numeric. I need to total all nymeric that have corresponding alpha data. (i.e do not total if there is no alph data).

What is the totaling expression?

Newby Paul

[johnw]

Perhaps this?

sum(if(len(trim(AlphaField)),NumericField))

This might be more efficient, though:

sum({<AlphaField*={">' '"}>} NumericField)

[#3]

John, thanks for your reply: Seems like I still can't get the right result. What I am trying to accomplish is to be able to take a list of sales quotes that wre made during the year and to be able to only total the dollar amount of those that were actually made into "jobs" ( Quote was accepted by customer) The data contains a field with the $$ of each quote and a field that is either blank ( not sold) or had a "job no" in it, meaning the quote was accepted. Just want to add up all those quotes that have and associated Job No.

" />

Newby Paul

[johnw]

Sorry for the delay. I've been very busy. In the attached example, the first expression works fine, and the second expression doesn't. A slightly different set analysis expression works, though:

sum({Job-={''}>} Quote)

If none of this works for you, perhaps you can modify and repost the example to demonstrate the problem you're having.

[#5]

Thanks John...I will try that