How to write the expression

[suvechha_b]

Hi ,

How to ommit the null division code :

See attachment:

For eg,

The NULL Division Code is summing up the "Budget Units" for other division code

I dont want the sum up of "Budget Units" in NULL Division Code.

Output should be "Budget Units":

CI10 9878

U001 12

How to write the expression for Inbound Orders , Blocked Stock and Actual receipts as they are not having division code.

See attachment.

[Gysbert_Wassenaar]

I dont want the sum up of "Budget Units" in NULL Division Code.

SUM({<[Type Indicator] = {'B'}, [Division Code]={'*'} >} Quantity)

Same for the other expressions.

[rubenmarin]

Hi, checking 'Supress null values' in [Division Code] dimension can be an option?

[marcus_sommer]

Beside your question - you have a lot of sythetic keys within your datamodel which could cause problems. Recomended is to resolve these sythetic keys, see for this: Synthetic Keys.

- Marcus