Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want help in the following things-
1. I want to find the max value from a range of values(each value comes from a different expression) and display it in KPI.
Like -
max(expression1, expression2, expression3, ....)
Is there a way to write such logic.
2. I have buttons for each expression. So when someone selects the button, my above Max(expression1, expression2, ..) should calculate the max value for only those expressions that is selected by buttons
1. Yes, use RangeMax()
2. It's doable using variables. Something like when a button is pressed, the expression is assigned to a variable and then all buttonvariables that have values are concatenated to fit in your rangemax expression.