Division by Zero Error - Not sure how to fix this 1

[Jeffs1977]

My formula:

{Data.Fee2}-{Data.Fee1}/{Data.Fee1}

When I run my report, I get a "Division by Zero" error. Can anyone assist me? Not sure what I need to do to fix this.

 

[Jeffs1977]

Would this be correct?

IF {Data.Fee1} = 0 then 0 else {Data.Fee2}/{Data.Fee1}

 

[jmd0252]

yes that would be a soultion to try

 

[Jeffs1977]

That fixed my Division by Zero issue, but I think I need help on my formulas.

I have 4 columns on my report

Fee 1
Fee 2
Fee Difference
% Change

The formula I used for my %Change was the one that created the "Division by Zero" error.

In looking at my data retuned, I have one like this:

Fee 1 = $200.00
Fee 2 = $385.00
Fee Difference = $185.00
% Change = 1.93%

I think I need help on my %Change formula. What would be the best way to report back a % diffence between Fee 1 and Fee 2?

 

[lbass]

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

-LB

 

[Jeffs1977]

lbass -

Thank you so much. I really appreciate the help.