If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#NUM! error
I am creating a report where we are trying to figure out our total
referrals by our bound referrals and the percents of bound referrals to the total. I am getting a #Num! error in my percentage field because I am diving 0 into 0 in the fouth quarter...I thought the NZ would eliminate this error... Below is the code I have in there now, any recommendations? =(nz([Q1Bound])+nz([Q2Bound])+nz([Q3Bound])+nz([Q4Bound]))/(nz([Q1Total])+nz([Q2Total])+nz([Q3Total])+nz([Q4Total])) |
Thread Tools | |
Display Modes | |
|
|