SET ANALYSIS

[#1]

  I have created a table using set analysis, i just cant get my last column to work,

I want to sum up everything where CUST ends in _L4 but is not TELEPHONE_L4

SUM({$ <[CUST] = {"*_L4"}-{"TELEPHONE_L4"}>[revenue])

What syntax do i need for this?

Also does set analysis heavily increase the memory usage as my document appears to be a lot slower?

[swuehl]

There is a closing curly bracket missing before [revenue]:

SUM({$ <[CUST] = {"*_L4"}-{"TELEPHONE_L4"} >} [revenue])

If that doesn't help, what exactely do you mean with 'can't get my last column to work'. Some sample input data, the context of your expression and expected outcome might help to understand.

[jerrysvensson]

Try:

SUM({$ <[CUST] = {"*_L4"}, [CUST] = E({<[CUST]= {"TELEPHONE_L4"}>} [CUST]) >} [revenue])

[alexis]

Try this:

Sum({$<CUST={"*_L4"},CUST-={$(=TELEPHONE_L4)}>}revenue)

regards

Alexis

[Anonymous]

Try Like this

Sum({$<CUST = {"*_L4"}-{'TELEPHONE_L4'}>} [revenue])

The above expression will gives the output as

Sum of revenue excluding the TELEPHONE..

[sujeetsingh]

Can try iff