How to supress showing of zero value

I have datawindow with 10 similar double field for edit.  During runtime, I will try to insert 10 rows to the DW control and make it become a 10x10 field for input value. Now since I need to compute the subtotal for rows and columns and so I intialise each field with zero.  However, for easy viewing, I would like to suppress showing all the zero value.  I've try to set a rule in the datawindow object in the column.color attribute, like "if ([column] = 0, rgb(255,255,255), 0)"  However it doesn't work well since when I try to input value, since the font color is now white(same as backgroud), I can't view the value before I jump to another field. Do anyone have other good and easy suggestion?
Who is Participating?
BhattiConnect With a Mentor Commented:
Hi Kokan

I think you need not to change the color in your coulumn to disable the value and again change color.
For your values use the format in Expression of datawindow column properties or you computed field properties.

You can also use the Modify function to adjust your format and also the string function to adjust the format.

Let me know, may I write you some codes.
Set the format of all the fields to '#' (# is zero supression)
Use editchanged event:
If data argument is != 0, change the color back.

If this is not clear - I will send you the code.
kokanAuthor Commented:
Finally, I done it by put the formula [ if [column] = 0, "#", "0.00" ] in the format attribute of the column object.  It works very fine!  Thank you for all of you's valuable suggestion.
All Courses

From novice to tech pro — start learning today.