% Change Formula help needed. 1

[Jeffs1977]

I have 4 columns on my report

Fee 1
Fee 2
Fee Difference
% Change

I need to report back the fee difference and % change between the fees. I recvd help on an earlier post and thought it was working right. This was the formula I was provided.

If {Data.Fee1} <> 0 then
({Data.Fee2}-{Data.Fee1})%{Data.Fee1}

In looking at my data retuned:

Fee 1 = $6.00
Fee 2 = $9.00
Fee Difference = $3.00
% Change = 50.00

The % Change is coming up 50.00 in a $3.00 change. Can I get some help on this formula?

 

[CR85user]

Fee 1 = $6.00
Fee 2 = $9.00
Fee Difference = $3.00
% Chang = 50.00

Is that not correct? 50% of $6.00 is $3.00.... What percentage were you expecting?

'J

CR8.5 / CRXI - Discovering the impossible

 

[Madawc]

You could make it

If {Data.Fee1} <> 0 then
({Data.Fee2}-{Data.Fee1})%[b]{Data.Fee2}[/b]

That should give 33.33%, is that what you want?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Jeffs1977]

Thanks!

 

[lbass]

You need to select the result and click on the % icon, also.

-LB