|
If you are wanting the value to still print and as a positive number, then you CAN DO this is Query. After you have created your calc field (C = A - B) and you have selected it to print on the report/screen, go to the Specify report column formatting. Page down until you see your new field (C), position your cursor on any field on this fields line and press F16. You can not show the negative a couple of ways: FIRST: Make the Edit Option a 1 and Press Enter. You will see an option to Show Negative Sign, make this an N and Press Enter. SECOND: Make the Edit Option a 3 and Press Enter. In the Edit Code field enter a 1 or 3 and Press Enter (You can press F1 in the Edit Code field to see what the various values will do to the field for displaying). This should give you a positive value for all of the results. Jim Rubino Senior Programmer Analyst FIKE CORPORATION (r) 704 South 10th Street Blue Springs, Mo. 64015 * Direct Dial - (816) 655-4579 * Or - (816) 229-6216 Ext. 1079 * Jim.Rubino@xxxxxxxx world Software Technical Editor for JDEtips -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] Sent: Thursday, January 27, 2005 9:20 AM To: 'midrange-l@xxxxxxxxxxxx' Subject: Trick math for Query 400 I need a simple report to come out of Query but one column must not go negative. In the define results screen this field is defined as a simple C = A - B but we do not want C to be negative. We would like to have a zero instead. A and B are both 7 digit numbers with no decimals. Is there any trick math that would do this? Thanks, Greg -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.