Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Jeffs1977
  • Order by date
  1. Jeffs1977

    % Change Formula help needed.

    Thanks!
  2. Jeffs1977

    % Change Formula help needed.

    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...
  3. Jeffs1977

    Division by Zero Error - Not sure how to fix this

    lbass - Thank you so much. I really appreciate the help.
  4. Jeffs1977

    Division by Zero Error - Not sure how to fix this

    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...
  5. Jeffs1977

    Division by Zero Error - Not sure how to fix this

    Would this be correct? IF {Data.Fee1} = 0 then 0 else {Data.Fee2}/{Data.Fee1}
  6. Jeffs1977

    Division by Zero Error - Not sure how to fix this

    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.

Part and Inventory Search

Back
Top