Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to supress a row of data measures based on the value for the dimension. For example, I have three columns of data, the first being a Dimension (FV Level) and the other two (CY Value, PY Value). I believe the way do this is by using the Settings for Selected Dimension:Enable Conditional. I'm unclear on what syntax I need to use when trying to limit. Essentially I want to show rows where the FV Level <> (not equal) to "[NULL]". Any thoughts or ideas?
The "Settings for Selected Dimension:Enable Conditional" is to either show or hide a dimension completely based on the condition you put in there. If you don't want to show a value from a dimension..
Add a calculated dimension like this instead...
if([Fair Value Level]<>'[NULL]',[Fair Value Level]) and make sure 'suppress when value is null' is checked..
Hi
Select Properties, tag dimensions the option Suppress When Value is Null
I hope help you!
Jannet,
Thank you for your prompt response, however, I tried that and realized the value is a text string "[NULL]" and not an actual [NULL] value. The data I'm using is coming straight out of an excel spreadsheet and not a relational database.
Jeff
Try,
Add Calculated Dimension,
=if([Fair Value Level]<>'[NULL]',[Fair Value Level])
The "Settings for Selected Dimension:Enable Conditional" is to either show or hide a dimension completely based on the condition you put in there. If you don't want to show a value from a dimension..
Add a calculated dimension like this instead...
if([Fair Value Level]<>'[NULL]',[Fair Value Level]) and make sure 'suppress when value is null' is checked..
Thank you both. The formula Jannet provided worked and I did have to select the check box for 'Suppress when value is null'.