Discoverer Plus Calculation for Cash Management

Rod Everitt

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

mrigg

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?

Rod Everitt

Thank you. This caluclation si now working, apprecaite your help