Straight Table Displaying null values

[ashokunbi]

I have a straight table that I don't want displaying null values.I read a comment that said I can control the value I don't want displayed by making the dimension suppress null values and making expression values I don't want as null values so I have the expression below:

If(1-MAPE >.70,null(), 1-MAPE)

The column is displaying values less than 70% and setting values higher than 70% as null, -, but I don't want it to display the null values period.  Below is an example of what I'm getting.  Please help.

AvailableWeek	ABS Variation	MAPE	FCA
34	29	51.7%	48.3%
34	11	11.0%	-
34	9	35.0%	65.0%
34	19	50.9%	49.1%
34	143	43.3%	56.7%
34	48	75.0%	25.0%
34	0	100.0%	0.0%
34	6	16.6%	-
34	7	21.2%	-
34	3	27.7%	-

[sinanozdemir]

Hi Ade,

This might be what you are looking for:

And then in the presentation tab, choose "Suppress Zero-Values":

Hope this helps

[ashokunbi]

Sinan, Thanks for your help but that didn’t work. The null values are still displayed.

[Anonymous]

Not exact but one option is to have MAPE as a expression with FCA.

Please see the the file attached.

Hope This will give some idea.

[sinanozdemir]

Hi Ade,

Try to change the expression to the below:

And then in the presentation tab, check "Suppress Zero-Values".

[ashokunbi]

Nope. It just turned all the values to 0%. Thanks for your help.

[sinanozdemir]

Is your original dataset different than what you previously posted?

Can you post a bit more comprehensive dataset?

[ashokunbi]

There is model column which I have added below (has no impact on the calculations, I think) but there are 3 other disabled columns that I used to get the values for the ABS Variation field. Available week and Model are dimension fields.

[sinanozdemir]

So FCA isn't an expression, is a dimension, correct?

[ashokunbi]

Week Available and Model are the only dimensions, all else are expressions.