Hi,

I am using OI7.2 and have created a symbolic that adds a row across a number of columns in an edittable. The calculations are correct, but I would like it if the result is 0, the display is blank. It is a somewhat large edittable and all the 0's are a distraction. The form would look better if the cell was empty. I have tried "if….then" but can't seem to find the correct combination. How do I get @Ans=" or whatever to make the result a blank?

TIA,

Marty

Given that you said you tried "if…then" and you still get zeros rather than blanks, I would consider that it is your output conversion that is causing the zeros.

Assuming that you are working with numbers, if you were to add a "Z" to the Oconv masked decimal function, it will make zero results look like blanks.

OUTPUT_NUMBER=OCONV(NUMBER,'MD2,Z')

This works with any "MD" OCONV conversion.

Richard,

Thanks for the response. I created a test button to extract the data from the column (TEXT_BY_POS) and saw the column data. I then thought to "Convert 0 To "" In ColumnData" and tried it in my symbolic. That did the trick. I will eventually have about 15 columns on this edittable that I will be using this format.

Thanks again,

Marty

Hi Richard,

At first I was having difficulty with the decimal point placement. Some of the results have decimal places. I created a loop and multiplied each number and then scaled in the OConv. The result is what I am looking for.

Thanks for your help,

Marty

View this thread on the forum...