COMPUTED FIELD (CASE STATEMENT)

[dkeeley]

Hi,

I am having problem with creating CASE statements in calculated fields. I am getting continuous server error messages.

David.

[jpiggee]

Hi David,

I moved this to a new topic for better visibility.

Can you please describe what you are trying to do with a CASE statement, as well as the type of Fields you are using so that we may better help you.

[nguyentru · Accepted solution]

Hi David,

We understand the issue, and we are in the process of fixing this bug.  It should be release soon.

In the mean time you will need to inser Else statement into your case statement have the computed field work.

For Example:

CASE 

WHEN(TYPE=4) and (RATE is not null)

WHEN(TYPE=1) and (COST is not NULL)

ELSE 0

END

THANKS,

Trung