Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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)
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)
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)