Calculated field in Report Writer, I need help

(0) Share

Report

Posted on by Mike Vaughn

Have a report based on em00103 that shows customer # and aging period amounts (array 1-4). Accounting department has asked if an amount is system default credit (1234.33) if I can set the field to zero. The report is passed on the a credit reporting agency that has no need of a credit balance. I have gotten into the calculated field 'wizard' and started to create one. I can pick the filed, pick the array index but how to i specify if the amount is credit to set to 0 and if not use the value. What do I say field is equal to?

*This post is locked for comments

All responses (4)

Answers (0)

Mike Vaughn 95 on at

Like (0)

Report

Re: Calculated field in Report Writer, I need help

Anyonr point me in the direction how to check the balance and out zero if the balance is negative
Mike Vaughn 95 on at

Like (0)

Report

Re: Calculated field in Report Writer, I need help

can you point my in the direction on how I specify the if balance if less than zero> Not sure how to build the if statement, ie not sure hwat to select, type etc.....
L Vail 65,271 on at

Like (0)

Report

Re: Calculated field in Report Writer, I need help

You need to use the Conditional form of a calculated field. If the balance is less than zero, print 0, otherwise print the field balance.
Mike Vaughn 95 on at

Like (0)

Report

Re: Calculated field in Report Writer, I need help

that shoud say rm00103, sorry