Hi,
I have a field - mylist which is a multi-value field, seperated by new line.
Then I have a multi-value field - outR which does a calcualtion on the field - mylist. Both fields are text fields.
However, I get the error:
“Field ‘outR’:Incorrect data type for operator or @Function:Text Expected”.
Below is the formula:
@Transform(mylist; “x”;
@Do(
_pos := _pos + 1;
_mod := @Modulo(_pos; 5);
@If(_mod = 1;
@Do(
_min := x;
_max := x;
“-”
);
@Do(
_min := @Min(x; _min);
_max := @Max(x; _max);
@If(_mod = 0; @Text(_max - _min); “-”)
) ) ) );