Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Discoverer Plus Calculation for Cash Management

Rod Everitt
Member Posts: 3 Blue Ribbon
Hi
We have created a Disco Plus report for Cash Mgt reconcilaiton report. All amounts appear as postivie figures. We want to create a calculation in Disoc to show negative amounts based on the Transaction code. If Transaction Code = 123 then Amount = - something along these lines
Can anyone recommend a formula we can use in the report?
regards
Rodney
Answers
-
Couldn't you just create a calculation to do what you describe? Something like "CASE WHEN Transaction Code = 123 then Amount * -1 else Amount END" Or are there more complications?
-
Thank you. This caluclation si now working, apprecaite your help
This discussion has been closed.