cancel
Showing results for 
Search instead for 
Did you mean: 

Minimal functions available for expressions

BenCodiroli
Level 2
Why are there so few functions available for use in Expressions, specifically with Number functions? I'm looking for a simple Max() function to just return the max of 2 numbers for use in an expression and this is not an option. Is there any way to import or create new functions for use in Expressions?
2 REPLIES 2

AmiBarrett
Level 12
If the data source is a column in a collection, you can use Linq to run aggregate SQL queries against the DataTable, such as max(). If you're only working with two numbers though, it should be fairly simple with a decision stage to see which is larger. [Decision][x]>[y]? Yes -     [Calculation]In: [x]; Out: [Value] No -     [Calculation]In: [y]; Out: [Value]

BenCodiroli
Level 2
I was hoping to be able to use a Max function inside of a longer expression, but I guess I could create a new stage and variable to perform that calculation prior to the expression...that's just not ideal.