I've had an extended absence from Crystal and, it appears I'm a bit rusty. I'm using Crystal XI to write a reasonably simple report for our finance dept of gl transactions and have run into a problem. The report is;

cost_code_cr    cost_code_dr    movement_value

10-1130                            110.00
                   10-2085        110.00
10-1030                            350.00
                   10-2085        350.00

I want the 'movement value' in the 'cost code cr' line to display as a negative. I've written this formula;

if isnull ({gl_trans.cost_code_dr}) then ({gl_trans.movement_value}*-1)
else {gl_trans.movement_value};

But it has no effect on the report. Any ideas??

The 'cost code dr' & 'cost code cr' fields are both strings and the 'movement value' field is a number.

Thankyou in advance

are you displaying the formula field in place of the movement value field?

At the moment I have the formula field as well as movement value on the report to see if the formula worked.
I've also done some debugging and it returns false for all lines.
The movement value field is only one field, not two. I need the report to look like this for display purposes, and I'm going to need some totals at the end as well.

cost_code_cr      cost_code_dr   movement_value

10-1130                            -110.00
                    10-2085        110.00
10-1030                            -350.00
                    10-2085        350.00

Thanks very much



Edited by duffey01 - 03 Feb 2015 at 12:15pm

Hopefully Vimal's formula resolves this for you.

Thanks DBlank, you've done it again!

I debugged it using your formula and got the True/False results, then used that in a if/then/else formula to display the negatives where I wanted them.

Thank you so much. I was pretty sure if I could get a Boolean to display I would be on my way, but I never would have thought of an 'empty string'.