Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Try:
SUM({$ <[CUST] = {"*_L4"}, [CUST] = E({<[CUST]= {"TELEPHONE_L4"}>} [CUST]) >} [revenue])
Try this:
Sum({$<CUST={"*_L4"},CUST-={$(=TELEPHONE_L4)}>}revenue)
regards
Alexis
Try Like this
Sum({$<CUST = {"*_L4"}-{'TELEPHONE_L4'}>} [revenue])
The above expression will gives the output as
Sum of revenue excluding the TELEPHONE..
Can try iff