Can it work?

[#1]

I need to make this expression work. Any body has any idea?

SUM({$<TEXT(CUSTOMER_NUMBER&DIVISION)={'13715DNE'}>} DOLLAR)

CUSTOMER_NUMBER = 13715

DIVISION=DNE

Thanks,

Nima

[m_woolf]

Concatenate CUSTOMER_NUMBER&DIVISION in script as NewField,

then use NewField in set analysis?

[#3]

I don't want to change any thing in script. that's why I want to do it in expression.

[#4]

It would be easiest to do it in the script, but you could use an IF statement if you needed it as an expression.  If(CUSTOMER_NUMBER & DIVISION='13715DNE',sum(Dollars) and then suppress nulls.

[#5]

Sorry add one more ) at the end

[#6]

The problem is that there is many of them and I want to compare all of them. That's why I used {}.

[#7]

Do you have a sample file of what you are looking for?

[rwunderlich]

You can't use a function on the left side of the "=". So do it as two modifers like this:

SUM({$<CUSTOMER_NUMBER={13715}, DIVISION={DNE}>} DOLLAR)

-Rob

[#9]

I had no choice . I had to do it in script.

Thanks to all