Question: Is there any documentation to help in discussing calculated/derived values showing grey/black values?
Updated 2 years ago
Version 3.0•Generally, derived values are dependent upon Scenario No Data zero view settings or overrides to the Account No Data Zero View Settings which dictate how the system interprets the lack of data on an intersection basis.
•In cases like the below, data that doesn’t change YTD based on the no data zero view settings will appear as grey.
•You can set a text color on the Cubeview (i.e black) so all values show in a single colour, which would override the default grey/black.
•You can also use a UD8 dynamic rule to hide derived values in future periods, if necessary.
Source: Office Hours 2020-06-18.