Code:
"10" & LEFT({Data.GL Number} & SPACE(25),25) & LEFT({Data.Debit Amount} & SPACE(12),12) & LEFT({Data.Credit Amount} & SPACE(12),12)
Right now, my {Data.Debit Amount} and {Data.Credit Amount} are formatted incorrect and I sure could use some help, as I have a difficult client needing this yesterday. Right now, its coming out like this:
Code:
1002.1973.08PP $0.00 $90.00
I need it to not print the "$", the decimal and if zero, just be blank, not reported as a 0.00
Any help is deeply appreciated.