Expression and dimension

[#1]

Hello

i need to unify this dimension an expression in one expression....

calculated dimension:

=if((not wildmatch(DOCUMENTO,'*NDP*','*NCP*')<>0),DOCUMENTO)

expression:

sum(TREINTA)-sum({<ISSOTRX_Cartera={'N'},TIPO={'FC'}>}TREINTA)

how i could do this?

Tnks...

[Gysbert_Wassenaar]

Your question doesn't make sense to me. You can make your sum expressions disregard records where DOCUMENTO contains the substrings NDP and NCP. If that's what you want try:

sum({<DOCUMENTO -= {'*NDP*','*NCP*'} >}TREINTA)-sum({<DOCUMENTO -= {'*NDP*','*NCP*'},ISSOTRX_Cartera={'N'},TIPO={'FC'}>}TREINTA)

[#3 · Accepted solution]

What are you trying to accomplish?

From your description I understand you want to show only the DOCUMENTS that doesn't match with '*NDP*' or '*NCP*'.

So... you could try this:

sum({<ISSOTRX_Cartera={'N'},TIPO={'FC'}, DOCUMENTO={'*'}-{'*NDP*','*NCP*'}>}TREINTA)