Hi all, wanted to confirm an understanding regarding the Max() function and Formula tool as a means of dynamically identifying a largest value in a column and then using that result against another column.
After Googlin' and looking at the documentation (https://help.alteryx.com/current/designer/minmax-functions), is it correct to say that you can't combine the two to do a dynamic Max value lookup on your dataset columns, especially if column values are non-integers (think: calendar dates)?
For example, you can't write something in the Formula tool like: [column value A] > max([column value B]), correct?
It looks like at best, if you want to identify a max value using ONLY the max() and Formula tool:
- Your values would have to be integers.
- You would have to creatively write a Bound() statement within a IF-statement and hard code in upper/lower bound values so that ideally your data would never exceed. For example: IF Bound(column[A],-999999,999999) THEN "option A" ELSE "option B" ENDIF.
For now, it seems like if you want to dynamically identify the max value of a column, you have to utilize Sort() or Summarize() in some form or another?
