Contributor III
2015-08-27
06:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Straight table displaying null values
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 make 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. Please help.
1,991 Views