You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Conditional Suppression Based on Date

We are trying to use Conditional Suppression to suppress rows based on a date. In Planning, users enter a date at an Account set to a Data Type of "Date." This same intersection is pulled into a report in Narrative Reporting. We would like to be able to set up conditional formatting to suppress rows if the date is prior to December 31st, 2023.

Based on testing, it appears that the "Date" in NR is text based. Therefore, we cannot use the greater than/less than operators to evaluate the date as a value. Attempting to use Planning date value (for example 20231231) also did not work. We can only get the suppression to work if we use the other operators and specify the specific date as it appears in the report (for example, Dec 5, 2036) which is not a dynamic/usable solution.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!