Results 1 to 2 of 2

Thread: problem report

  1. #1
    Join Date
    Nov 2003
    Posts
    20

    Unanswered: problem report

    hi guys,
    i have to create un colunm in a report where i put the result of my function: =CSng((Nz([2004])*100/Nz([2003]))-100).
    this column calculates the difference percentage between 2003 and 2004, but if 2003 or 2004 are null or = 0 i have this message #Div/0!.
    I 'd like to visualize only real percentages and nothing where i have not values
    thanks

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Try this:

    =CSng((Nz([2004])*100/Nz([2003]), 1)-100)

    Another approach:

    =CSng(iif(IsNull(2004), iif(IsNull(2003), "", ""), 2004 * 100 / 2003 - 100))
    Last edited by Teddy; 08-02-04 at 10:45.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •