Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Conditional Formatting or Highlighting for NULL records

Is it possible to highlight a record with a NULL value using the highlighting expert or conditional formatting?

I've tried the formula: "if isnull({@ROI_Actual}) then crYellow else crWhite" in the background conditional formatting window but haven't been successfull in highlighting the NULL values.

It also appears that the highlighting expert does not accept NULL in the "vaule of" section.

Does anyone know of a way to bring attention to the NULL values? I prefer not to use an IF THEN statement to replace the NULL with an actual value and then set formatting on that created value.

Thanks very much for any help that you can provide!!

David

replied

Hi David,

If the formula returns null value then formula will not be processed in crystal. So you need to convert the null values to default. You can find this option in the formula editor at the top in a drop down list in which the default option is "exception for nulls" change this option to "Default values for nulls". Now the null values are converted into 0 if it is a numeric field and if it is a string field then it converts to "".

Now change the condition like

if =0 then cryellow else crwhite if it is a string field then write the formula like if ="" then cryellow

else

crwhite

Regards,

Raghavendra

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question