Dear experts

[jjvicenza1930]

How can I exclude some field names in a dimension. For example: I want to present a graph of a Region consist of Europe, North America, Oceania, Asia, Not Relevant and blanc. I want to exclude Not relevant and blanc. I solved this by the following formular:

Sum({<APG_REGION_NAME = {"Europe", "North America", "Oceania", "Asia"}>} MARKET_VALUE_APG_BASE)/1000000

But I want to know how to exclude the names Not Relevant and the blanc field

Thanks in advance

Best regards

Xandro

[sunny_talwar]

You already have solved this, right?

Sum({<APG_REGION_NAME = {'Europe', 'North America', 'Oceania', 'Asia}>} MARKET_VALUE_APG_BASE)/1000000

This isn't excluding Not Relevant and blanc?

[jjvicenza1930]

Yes

But I was wandering if there was an alternative method to exclude the two.

Best regards

Xandro

[Anonymous]

Are you looking to exclude the fields completely from the data model? This can be done by commenting out the fields i.e //Not Relevant.

[Aurelien_Martinez]

Hi,

Sum(({<APG_REGION_NAME -= {'Not Relevant'}>} MARKET_VALUE_APG_BASE)/1000000

[#6]

Maybe this

Sum({<APG_REGION_NAME ={"*"}-{"Not Relevant"}>} MARKET_VALUE_APG_BASE)/1000000

[sunny_talwar]

There is this:

Sum({<APG_REGION_NAME -= {'Not Relevant', 'blanc'}>} MARKET_VALUE_APG_BASE)/1000000

or

Sum({<APG_REGION_NAME = e({<APG_REGION_NAME = {'Not Relevant', 'blanc'}>})>} MARKET_VALUE_APG_BASE)/1000000

[jjvicenza1930]

The field name Not Relavant and the blanc field name should be excluded from the dimension APG_REGION_NAME.

The field name Not Relevant can be excluded by the formular Sum({<APG_REGION_NAME -= {'Not Relevant'}. Now I am looking how to exclude the blanc field name. Is there a formular to exclude blanc field names.

Thanks in advance.

[jjvicenza1930]

I found the solution with thanks to all of you. The correct answer is:

Sum({<APG_REGION_NAME -= {"Not Relevant", ""} >} MARKET_VALUE_APG_BASE)/1000000

Thanks again to all of you for your support.

Best regards

Xandro

[Anonymous]

Hi,

Sunny's second condition below should work :

Sum({<APG_REGION_NAME = E({<APG_REGION_NAME = {'Not Relevant', 'blanc'}>})>} MARKET_VALUE_APG_BASE)/1000000

Only please ensure how the Blank is defined ' ' or Blank or blanc etc... how is it appearing in the source..

Thanks