Cube View Cell Displaying Error Message

FM
New Contributor III

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.

2 REPLIES 2

LeeB
Contributor II

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

 

FM
New Contributor III

@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.