Include NULL values in expression

fab_castanheira — Wed, 27 Dec 2017 15:18:03 GMT

Hello everyone,

I have the following (simplified) data model, where the blanks in DimB are NULL values :

The business requirement is to display the following chart with :

- Dimensions :

- DimA (lines)

- DimB (columns)

- Measures :

- Result (sum of Ind where DimB isn't null)

- TotalResult (sum of Ind whether DimB is null or not)

I am having a hard time calculating TotalResult, because I need to include NULL values without displaying an extra column for DimB (which was what I obtained when replacing NULL values with a blank in the script, and the users won't accept it).

I would be grateful for any help you could provide, please don't hesitate to ask for more details if my example isn't explicit enough.

Best regards,

Fabio

Re: Include NULL values in expression

sunny_talwar — Wed, 27 Dec 2017 16:40:25 GMT

How do we know which null is associated with which value of DimB? Do they always load together (just like in your example)?

Re: Include NULL values in expression

fab_castanheira — Thu, 28 Dec 2017 09:12:32 GMT

Hello Sunny,

You're right the example is wrong, I'm going to correct it.

topic Re: Include NULL values in expression in App Development

Include NULL values in expression

Re: Include NULL values in expression

Re: Include NULL values in expression