The short version of what I'm trying to accomplish is to show the absolute value of a coordinate in a data tag (for instance, if the coordinate is -20'0" on the X axis, I just want it to say 20'0"). I'm essentially dimensioning from a 0,0 point and the direction (which would be expressed as positive/negative) is irrelevant.
I do this in worksheets with a simple if/else formula: =IF((XCOORDINATE>0), XCOORDINATE, -(XCOORDINATE)) because I haven't run across an easier way. Some spreadsheets have an ABS(value) function, but I don't see this in VW.
My questions are:
- is it possible to put a a formula such as this in a data tag? I haven't had any luck, it just displays as text, but maybe I don't have the right syntax.
- either way, is there an easier way to get the figure I'm looking for?
Thanks,
Brian