topic Re: Adding '>=' OR '<=' Variable to Set Analysis in App Development

Adding '>=' OR '<=' Variable to Set Analysis

cfountain72 — Mon, 17 Oct 2022 13:35:29 GMT

Good Morning,

I am trying to insert a variable representing greater than or less then ('>=' or '<=') into a set analysis expression. The default section is:

EVS_OVERALL_TURN_TIME={"<=$(=fractile({<EVS_InpCleanFlag= {'1'}>}EVS_OVERALL_TURN_TIME, $(v_Outlier_ile)))"}>}EVS_OVERALL_TURN_TIME)

What I want to do is allow the user to decide if they want to include values greater than or less than a value by selecting a variable value v_above_below to be >= or <=, but I don't know how the syntax would work...or even if it can work. It would be something like this:

EVS_OVERALL_TURN_TIME={"$(v_above_below)""$(=fractile({<EVS_InpCleanFlag= {'1'}>}EVS_OVERALL_TURN_TIME, $(v_Outlier_ile)))"}>}EVS_OVERALL_TURN_TIME)

Any suggestions? Or a different way to go about it? There a several expressions, so doing a bunch of if/then's isn't really practical in this case.

Thanks in advance for your help,

Chris

Re: Adding '>=' OR '<=' Variable to Set Analysis

rwunderlich — Mon, 17 Oct 2022 17:17:58 GMT

I imagine this would work. I think the syntax would be:

EVS_OVERALL_TURN_TIME={"$(v_above_below)$(=fractile({<EVS_InpCleanFlag= {'1'}>}EVS_OVERALL_TURN_TIME, $(v_Outlier_ile)))"}>}EVS_OVERALL_TURN_TIME)

-Rob

Re: Adding '>=' OR '<=' Variable to Set Analysis

cfountain72 — Mon, 17 Oct 2022 17:28:11 GMT

Thanks Rob! You da man! I guess I was just overcomplicating it, assuming there had to be some kind of punctuation between the variable and the next portion of the expression. Awesome!