Negative Number Style

[Data Kruncher]

Hi all. I'm using Monarch 5.01, and my problem is in trying to negative numbers on ERP system reports that some kind programmer setup like < 100.00>, instead of using -100.00 or even (100.00). The number shows up in my report as 100.00, instead of -100.00.

I see no option for controlling the negative number style. Is this in v6.x?

Please post your creative solution. TIA

[Steve Caiels]

Hi,
Nothing to help in v6, but you can create a numeric calculated field using:

if(left(orig,1)="<",-val(orig),val(orig))

This assumes orig is you original data that must be set as a character field.

Cheers
Steve