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 quater...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])) |
#2
|
|||
|
|||
#NUM! error
You need to use this basic syntax:
=IIf(Nz([some expression],0) = 0, 0, [Other Expression]/[some expression]) -- Duane Hookom MS Access MVP wrote in message ups.com... 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 quater...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])) |
#3
|
|||
|
|||
#NUM! error
Doesn't this make sense....
I am fairly new at VB... Duane Hookom wrote: You need to use this basic syntax: =IIf(Nz([some expression],0) = 0, 0, [Other Expression]/[some expression]) -- Duane Hookom MS Access MVP wrote in message ups.com... 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 quater...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])) |
#4
|
|||
|
|||
#NUM! error
Did you mean "this doesn't make sense"? If so, what don't you understand? Do
you have trouble seeing how to implement the IIf() with your expression? -- Duane Hookom MS Access MVP wrote in message oups.com... Doesn't this make sense.... I am fairly new at VB... Duane Hookom wrote: You need to use this basic syntax: =IIf(Nz([some expression],0) = 0, 0, [Other Expression]/[some expression]) -- Duane Hookom MS Access MVP wrote in message ups.com... 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 quater...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])) |
#5
|
|||
|
|||
#NUM! error
I am sorry, yeah I meant doesnt make sense.... I was going to attempt
to create my expression, but it just doesnt make sense....I would I create or start it... Duane Hookom wrote: Did you mean "this doesn't make sense"? If so, what don't you understand? Do you have trouble seeing how to implement the IIf() with your expression? -- Duane Hookom MS Access MVP wrote in message oups.com... Doesn't this make sense.... I am fairly new at VB... Duane Hookom wrote: You need to use this basic syntax: =IIf(Nz([some expression],0) = 0, 0, [Other Expression]/[some expression]) -- Duane Hookom MS Access MVP wrote in message ups.com... 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 quater...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])) |
#6
|
|||
|
|||
#NUM! error
Try this expression:
=IIf(nz([Q1Total],0)+nz([Q2Total],0)+nz([Q3Total],0)+nz([Q4Total],0) = 0, 0, (nz([Q1Bound],0)+nz([Q2Bound],0)+nz([Q3Bound],0)+nz([Q4Bound],0))/(nz([Q1Total],0)+nz([Q2Total],0)+nz([Q3Total],0)+nz([Q4Total],0))) -- Duane Hookom MS Access MVP wrote in message ups.com... I am sorry, yeah I meant doesnt make sense.... I was going to attempt to create my expression, but it just doesnt make sense....I would I create or start it... Duane Hookom wrote: Did you mean "this doesn't make sense"? If so, what don't you understand? Do you have trouble seeing how to implement the IIf() with your expression? -- Duane Hookom MS Access MVP wrote in message oups.com... Doesn't this make sense.... I am fairly new at VB... Duane Hookom wrote: You need to use this basic syntax: =IIf(Nz([some expression],0) = 0, 0, [Other Expression]/[some expression]) -- Duane Hookom MS Access MVP wrote in message ups.com... 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 quater...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])) |
#7
|
|||
|
|||
#NUM! error
It totally worked, thanks. I will keep this statement for my records
incase I run into this situation again. Duane Hookom wrote: Try this expression: =IIf(nz([Q1Total],0)+nz([Q2Total],0)+nz([Q3Total],0)+nz([Q4Total],0) = 0, 0, (nz([Q1Bound],0)+nz([Q2Bound],0)+nz([Q3Bound],0)+nz([Q4Bound],0))/(nz([Q1Total],0)+nz([Q2Total],0)+nz([Q3Total],0)+nz([Q4Total],0))) -- Duane Hookom MS Access MVP wrote in message ups.com... I am sorry, yeah I meant doesnt make sense.... I was going to attempt to create my expression, but it just doesnt make sense....I would I create or start it... Duane Hookom wrote: Did you mean "this doesn't make sense"? If so, what don't you understand? Do you have trouble seeing how to implement the IIf() with your expression? -- Duane Hookom MS Access MVP wrote in message oups.com... Doesn't this make sense.... I am fairly new at VB... Duane Hookom wrote: You need to use this basic syntax: =IIf(Nz([some expression],0) = 0, 0, [Other Expression]/[some expression]) -- Duane Hookom MS Access MVP wrote in message ups.com... 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 quater...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 | |
|
|