Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
See attached example.
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
Acutally, I set mine up as dropdown select with predefined values.