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]

Without seeing the application, it is a bit difficult to determine why mine works, but not yours.

You can also handle this in the back-end:

And your data model will look like this:

Post your sample app, I cannot open it. However, someone else can open it and see what's wrong.

[Qrishna]

See attached.

!

[Anonymous]

You must not want to suppress 0.0% as a FCA value from the table. Isn't following model work? or you can try the expression sent by Krishna.

[ashokunbi]

This is showing FCA over 70%. My values are not the issue, I just don’t want to display any FCA greater or equal to 70%

[Qrishna]

is this what you wanted?

see attached

[ashokunbi]

Thanks for your help. Sorry I couldn’t respond sooner. The suggestion is not working, it came up with the wrong values for FCA. I already have the correct values, I just don’t want to display any values greater than 70%.

I’m not sure if the issue is that you are using the value supplied in Mape as is (your expression for Mape is Mape & ‘%’) but it is actually the result of this expression:

if( > sum(RcvdQty), 1, /sum(RcvdQty))

I’m not sure if this helps.

[Qrishna]

Any luck>