Hi everyone,
I have a simple goal:
01. Pick two or more choices from a view, return integer values strung along
in a text variable
02. Somehow transform the values inside the variable back into integers and
add them up
So far, this is what I have:
CHOOSE vmilelist FROM #VALUES FOR DISTINCT (loc_desc &
(ctxt(plusminus))),plusminus +
FROM v_plusminus +
WHERE active_fl_28 = 'Y' +
ORDER BY loc_desc +
CHKBOX 0 +
TITLE 'Add Mileage' +
CAPTION 'LOCATIONS PLUS MINUS MILES' +
LINES 25 +
FORMATTED
SET VAR vmilelist = ('(' + .vmilelist + ')')
My choose looks like this:
DULAC-LA 3 <===
REDDELL-LA 8
MAMOU-LA 11
FRANKLIN-TX 5 <===
The value returned is 3 and 5 and the text variable vmilelist looks like
this: (3,5)
The result I want is integer 8, i.e. the sum of 3 and 5.
Can I get there from here?
TIA,
Claudine :)
