Forum Discussion

FM's avatar
FM
New Contributor III
3 years ago

Cube View Cell Displaying Error Message

Hello,

 

I have a requirement to display an error message in a cube view if the value of a cell is greater than the absolute value of 1000.

Under the Cell Format I have "If (CellAmount >= 1000) Or (CellAmount <= -1000) Then "

Is this approach correct? Is there an absolute value synthax that I could use?

Also what is the syntax that I can use to display an error message after the conditions are met?

 

Thank you for your time and best regards.

Cube View

2 Replies

Sort By
  • LeeB's avatar
    LeeB
    Contributor II
    3 years ago

    I don't believe you can use Conditional Formatting to display text in the cell, but rather change the standard format properties.

    Would it be sufficient to use traffic lighting? i.e. BackgroundColor = Red if you conditions are met.

     

     

    • FM's avatar
      FM
      New Contributor III
      3 years ago

      LeeB 

      Thank you for your suggestion. Sadly the traffic light approach is not enough in this case. 
      I looked into Cube View Extenders but thos apparently are only good for the reporting aspects of Cube Views. This is a oddly challenging thing to do which I expected to be a lot simpler.