Midrange News for the IBM i Community

Posted by: renojim
Credit balance in parens
has no ratings.
Published: 26 Jan 2012
Revised: 23 Jan 2013 - 1611 days ago
Last viewed on: 21 Jun 2017 (3227 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Credit balance in parens Published by: renojim on 26 Jan 2012 view comments(4)

How the heck do you get a credit balance to show in parentheses? I got this to work -

'0(        . 0)'

But then I lost zero suppression, and I can't get it back. Now a credit balance of $500.00 shows as (00500.00).

Return to midrangenews.com home page.
Sort Ascend | Descend