Edit Mask and Negative Numbers

Products

• CA Plex

Issue/Introduction

Software written in Plex 6.0 has been converted to version 7.3.

A field for money defined fixed decimal 11.0 does not function properly due to outdated edit mask

######,##0;[RED]-######,##0

when minus numbers are entered or displayed.

This is used in connection with ODBC driver for SQL Server 17/18.

How would a proper edit mask look like that displays minus numbers as red?

Environment

CA Plex 7.3

Resolution

The following mask will display the negative numbers properly:

###########,##0;[RED]###########,##0