Forum Discussion

hatcher78's avatar
hatcher78
New Member
3 years ago
Solved

Use Field Data as Operator

I want have the operator used in a custom column be based on the data in another field but keep getting an error.   For example, my dataset has the following fields Field A (The DataPoint)     Fie...
  • Mikelytics's avatar
    Mikelytics
    3 years ago

    Hi hatcher78 

     

    But I have another idea how you can to it:

     

    Measure =
SWITCH(
   SELECTEDVALUE([FieldB]),
   ">", IF([FieldA]>[FieldC],1,0),
   "<", IF([FieldA]<[FieldC],1,0),
   ">=", IF([FieldA]>=[FieldC],1,0),
   "<=", IF([FieldA]<=[FieldC],1,0)
)

     

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi hatcher78 

 

I really have never seen this anytime in any report so I would say it is not possible to transform a text field into an operator.

 

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

  • Mikelytics's avatar
    Mikelytics
    Resident Rockstar
    3 years ago

    Hi hatcher78 

     

    But I have another idea how you can to it:

     

    Measure =
SWITCH(
   SELECTEDVALUE([FieldB]),
   ">", IF([FieldA]>[FieldC],1,0),
   "<", IF([FieldA]<[FieldC],1,0),
   ">=", IF([FieldA]>=[FieldC],1,0),
   "<=", IF([FieldA]<=[FieldC],1,0)
)

     

    Best regards
    Michael
    -----------------------------------------------------
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Appreciate your thumbs up!
    @ me in replies or I'll lose your thread.