S
Steve B
Evening all.
Access 2000
I didnt' think my math was too bad but I'ms stuck in a rut with this
formating issue.
I have a field that is a basic sum of other fields shown below
=IIf(nz([Total Inbound Calls]),(Nz([15 Secs])+(nz([30 Secs])+(nz([45
Secs]))))/([Inbound Calls Answered]))
I'ts basicaly realtime data from a Telephone switch to show how fast calls
are answered
The current result in the field gives an answer of 0.0909090909090909 which
as a percentage is 9.09% using the percent format
Under conditional formating I have the following criteria
Condition 1
Field Value is - [less than or equal to] - 0.79 Colour the cell RED
Condition 2
Field Value is - [Greater than or equal to] - 0.8 Colour the cell GREEN
Now at the moment the 0.90909 result is turning the cell Green, when it
should be red.
I've used the same data in Excel, with the same formating and it works
correctly?
Any idea's
Access 2000
I didnt' think my math was too bad but I'ms stuck in a rut with this
formating issue.
I have a field that is a basic sum of other fields shown below
=IIf(nz([Total Inbound Calls]),(Nz([15 Secs])+(nz([30 Secs])+(nz([45
Secs]))))/([Inbound Calls Answered]))
I'ts basicaly realtime data from a Telephone switch to show how fast calls
are answered
The current result in the field gives an answer of 0.0909090909090909 which
as a percentage is 9.09% using the percent format
Under conditional formating I have the following criteria
Condition 1
Field Value is - [less than or equal to] - 0.79 Colour the cell RED
Condition 2
Field Value is - [Greater than or equal to] - 0.8 Colour the cell GREEN
Now at the moment the 0.90909 result is turning the cell Green, when it
should be red.
I've used the same data in Excel, with the same formating and it works
correctly?
Any idea's