Skip to main content
F
FM26
Newcomer
September 6, 2022

Cube View Cell Displaying Error Message

  • September 6, 2022
  • 1 reply
  • 0 views

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.

1 reply

L
LeeB
Contributor
September 7, 2022

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.

 

LeeBown_0-1662540129549.png

 

    F
    FM26Author
    Newcomer
    September 8, 2022

    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.

    Terms & ConditionsAccessibility statement