Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
joybratas1
Contributor II
Contributor II

How to get the Max value from a range of expression

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

Labels (2)
1 Reply
henrikalmen
Specialist
Specialist

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.