Forum Discussion

Ando's avatar
Ando
New Contributor II
3 years ago

UD8 Dynamic rule to hide derived values. Does anyone have an example of this UD8 calc?

  •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 der...
Finance
PatrickWWiggett's avatar
PatrickWWiggett
New Contributor III

This script won't hide the data, but will allow you to edit the colour of your derived data:

If (IsDerivedData = True) Then TextColor = Transparent

You can put that in your "Cell Format" for your applicable columns/rows.

Not sure if that helps?

Ando's avatar
Ando
New Contributor II
3 years ago

Would also want it hidden in a quick view in excel and don’t think this would accomplish that