If OR Statement

[Butlertl]

This is the statement but I am not getting any data....ie: when it should show a one I am getting blanks.

If {HPD_Help_Desk.CallCenterResponsePlatinumMetric}= "Pass" or
{HPD_Help_Desk.CallCenterResponseGoldMetric}= "Pass" or
{HPD_Help_Desk.CallCenterResponseSilverMetric}= "Pass" or
Then 1
Else 0

Any suggestions?

Thanks

Terry

 

[Butlertl]

Sorry...this is the statement:

If {HPD_Help_Desk.CallCenterResponsePlatinumMetric}= "Pass" or
{HPD_Help_Desk.CallCenterResponseGoldMetric}= "Pass" or
{HPD_Help_Desk.CallCenterResponseSilverMetric}= "Pass"
Then 1
Else 0

 

[lbass]

You need to check for nulls, so try:

If
(
not isnull ({HPD_Help_Desk.CallCenterResponsePlatinumMetric}) and
{HPD_Help_Desk.CallCenterResponsePlatinumMetric} = "Pass"
) or
(
not isnull({HPD_Help_Desk.CallCenterResponseGoldMetric}) and
{HPD_Help_Desk.CallCenterResponseGoldMetric) = "Pass"
) or
(
not isnull({HPD_Help_Desk.CallCenterResponseSilverMetric}) and
{HPD_Help_Desk.CallCenterResponseSilberMetric} = "Pass"
)
Then 1
Else 0

-LB

 

[Butlertl]

Thanks

 

[Butlertl]

It worked.

Thanks again.