[ARoberts18 Contributions: 0Level 1☆]

Hi there,

I'm trying to do this:

CASE WHEN {custrecord104.custrecord127} = '1'

THEN

CASE

WHEN {custrecordf} = 'No' THEN 'Requires Attention'

WHEN {custrecord136} = 'No' THEN 'Requires Attention'

WHEN {custrecord136} IS NULL THEN 'Requires Attention'

WHEN {custrecord75} = 'No' THEN 'Requires Attention'

ELSE 'OK'

END

END

CASE WHEN {custrecord104.custrecord127} = '0'

THEN

CASE

WHEN {custrecord136} IS NULL THEN 'Requires Attention'

WHEN {custrecord75} = 'No' THEN 'Requires Attention'

ELSE 'OK'

END

END

In one formula field but it isn't working. What's the correct way to do it?
This is a cached copy. Click here to see the original post.

[khultquist Contributions: 0Level 1☆]

Try this

Code:
CASE
WHEN {custrecord104.custrecord127} = '1' THEN
CASE
WHEN {custrecordf} = 'No' THEN 'Requires Attention'
WHEN {custrecord136} = 'No' THEN 'Requires Attention'
WHEN {custrecord136} IS NULL THEN 'Requires Attention'
WHEN {custrecord75} = 'No' THEN 'Requires Attention'
ELSE
CASE
WHEN {custrecord104.custrecord127} = '0' THEN
CASE
WHEN {custrecord136} IS NULL THEN 'Requires Attention'
WHEN {custrecord75} = 'No' THEN 'Requires Attention'
ELSE 'OK'
END
ELSE 'OK'
END
END
END

[ARoberts18 Contributions: 0Level 1☆]

Hi,

This works!

How do I combine these into one line:

WHEN {custrecorda} = 'No' THEN 'Requires Attention'

WHEN {custrecorda} IS NULL THEN 'Requires Attention'

I can't seem to get the OR statement to work.

[david.smith Contributions: 0Level 1☆]

WHEN ({custrecorda} = 'No' OR {custrecorda} IS NULL) THEN 'Requires Attention'

WHEN NVL({custrecorda}, 'No') = 'No' THEN 'Requires Attention'

[Author]

Posts