Small challenge Report 1

[idehen]

Seasonal Greetings to everyone.

Quick question:

I have a report that produces both positive and negative numbers. e.g

Acc_Balance
456.56
-4587.25
569.25
-4587.28

i want to create 2 new fields called credit and debits, where all negative/positive numbers from the above field should be displayed separetely, hence having something like this:


Acc_Balance Debit Credit
456.56 456.56 0
-4587.25 0 -4587.25
569.25 569.25 0
-4587.28 0 -4587.28

any ideas please. Thanks

Sol

 

[Katy44]

I would start by creating two formula fields:
@Debit: if Acc_Balance>0 then Acc_Balance else 0
@Credit: if Acc_Balance<0 then Acc_Balance else 0

Then just put these both on the report, side by side, with the appropriate headings.
This should work, but I haven't tried it, so let me know if it doesn't for any reason!

 

[idehen]

Thanks Katy44, Worked like a charm. Excellent!