Forum Discussion
Solved
Comparison sing inside dataset
Hello, I am searching for help with this unique example. I have in my dataset column with comparison sign. Is it possible to compare Value and use sing from the column? I want to create one ...
Hi kosa_seba ,
You would have to do this using a conditional column that defines what the text representation of the operator (Sign) means, and apply it to an appropriate calculation.
For example, your conditional column would have to be built something like this:
if [Sign] = "<" and [Value] < [SingValue] then "In Spec" else if [Sign] = ">" and [Value] > [SingValue] then "In Spec" else if [Sign] = "=" and [Value] = [SingValue] then "In Spec" ... ... else // your escape value e.g. "Not In Spec", null etc.Pete
Hi kosa_seba ,
You would have to do this using a conditional column that defines what the text representation of the operator (Sign) means, and apply it to an appropriate calculation.
For example, your conditional column would have to be built something like this:
if [Sign] = "<" and [Value] < [SingValue] then "In Spec"
else if [Sign] = ">" and [Value] > [SingValue] then "In Spec"
else if [Sign] = "=" and [Value] = [SingValue] then "In Spec"
...
...
else // your escape value e.g. "Not In Spec", null etc.
Pete