IIF function 1

[eshaan]

I have Access 97 report. On text field it is calculating
from three fields sum numbers like 20/10+7 = 17 and converting into percentage because I set property format as percent.

If there is 0 it is 0/0 = 0% but instead of that it is giving error #Num! It is not printing 0%

If I want to write code in expression builder
If xfield = 0 then
? "None"
Else
= ([sumy]/[sumofy]+sumofN)
Endif

How can I write in Expression builder above code.I wrote in IIF function some have it is not working.

Please urgent.

 

[TheAceMan1]

How are ya eshaan . . . . .

Your getting the equivalent of an [blue]Divide By Zero Error[/blue]. So according to descriptors in you formula:

[blue]IIf([sumofy]=0, 0, ([sumy]/[sumofy]+sumofN))[/blue]

See Ya! . . . . . .

 

[eshaan]

What I did wrong? Please help me.

IIF([SumOfYesScore]=0,0,([sumofyesscores]/[SumOfYesScore]+SumOfNoScore))

Giving error Syntax error (comma) in query expression

 

[eshaan]

please help me urgent

 

[TheAceMan1]

eshaan . . . . .

Can [blue]SumOfYesScore[/blue] be [purple]Null[/purple]?

Try brackets where you see them below.
[purple][[/purple]SumOfNoScore[purple]][/purple]

If that does'nt work, post the query . . . .

See Ya! . . . . . .

 

[CajunCenturion]

20/10+7 = 17

Is there something missing here?

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[TheAceMan1]

How are ya CajunCenturion . . . . .

I took it as some kind of typo glitch! ;-) Don't wanna believe the general math is . . . . . .

See Ya! . . . . . .