Positive to Negative Values 1

[DOMAL]

I have experienced this problem at two of my employers, both have been unable (or unwilling) to find a solution and the problem is time consuming!

Basically i download data off of a financial ledger. Each transaction has a different code for example.
1 - income
2 - Debit Transfer
3 - Credit Transfer
4 - Invoice
5 - Credit Note
6 - Debit Adjustment
7 - Credit Adjustment

Codes 3, 5 and 6 are always negative values, but do not show as such in the report.

For some reason when taking this information off the ledger they come out as positive values, is there a way to make these show as negative on the report and as such make the final total correct for my purposes?!

I dont know too much about Crystal but i know that when using excel forumlae that if one cell returns X Value then other cell *-1. Can something similar work here?

I know its a bit of a NOOB question, did try searching but it is down for maintenance.

Thanks

DOMAL

 

[Bloke152]

one way is to create a formula field and multiply the fields by -1, this will reverse the value so a plus number will become a negative.

 

[DOMAL]

Sorry, this report contains all of the above transactions, so multiplying all fields would give the same effect to values that should be positive.

 

[Bloke152]

you'll need to do an if statement, something that will separate the ones you want to oppisite, something like below.

if {code} in[3,5,6] then {value} * -1
else 1=1

 

[dgillz]

if {code} in [3,5,6] then {YourField} * -1 else {YourField}



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[DOMAL]

Thanks but i still seem to be getting an error.

I was using the formula noted above by dgillz.

I get the error 'a string is required here'

Now i am using Crystal Version 8.50.0.217 if that makes any difference. Apologies i didnt make a note of this earlier.

Any Ideas?

Cheers

DOMAL

 

[Bloke152]

you could try converting it to a string,

if {code} in [3,5,6] then {YourField} * -1 else
cstr({YourField})

 

[dgillz]

Please post your entire formula verbatim, no {field1}, the exact formula please.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

My guess is that the code is a string, so the formula should be:

if {code} in ['3','5','6'] then {YourField} * -1 else
{YourField}

-LB