Using greater than as a variable from inputbox inside set analysis

[Anonymous]

The title might be confusing so I will clarify. I have 2 inputboxes. The first inputbox contains (>, =, ) . The second inputbox will accept number of Days.

Example: User picks '>=' from a dropdown select and 5 as number of days. It will store both values as variables. Instead of using '>=' as in the formula below, I want to put the '>=' in the stored variable in its place instead.

=sum({$<

[Year] = {2012},

[Days between shipping] = {">=$(=$(vDays))"}

>}[Revenue])

I tried various ways so posting for help was my last option. Thank you for your help.

[Gysbert_Wassenaar]

See attached example.

[Anonymous · Accepted solution]

I will suggest don't use inputbox for operator selection give user a list box for that just load inline

all operator which you want to give as option so that user can maintain integrity as well (avoid typo)

then create a variable with

vOperator=GetFieldSelections(Operator)

then use variable in your set analysis

$(vOperator)

PS: Operator is column name

Thanks

BKC

[Anonymous]

Acutally, I set mine up as dropdown select with predefined values.