I have data located in bdd with yes/no values that I would like to reconcile. For that, I would like to transform my text values into an integer. Is this possible? and how?
I tested it in two functions but it still gives me the error message that one cannot make a sum of text value.
I tested by creating a variable with this function
expression: IF((data)="Yes",1,0)
expression initial value: data.getValue.parseInt(Yes,1)
and the second test is:
expression: Integer.valueOf(IF((data)="Yes",1,0))
initial value expression: 0
If you can help me.