09-06-2022 11:08 AM - last edited on 05-24-2023 11:36 AM by JackLacava
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.
09-07-2022 04:42 AM
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.
09-08-2022 12:06 PM
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.