Hi there,

I would like to make a feature request for the Calculated Field builder in the report builder for Yellowfin.

Occasionally, the data that a report selects happens to be NULL.
If there are other calculated fields relying on this column, the calculation will result to NULL.

What I currently have to do to work around this issue is use lots of
CASE WHEN IS NULL THEN 0 ELSE END
components in my calculated fields in order for them to function correctly.

This is time consuming, error prone and makes the entire formula difficult to read.

It would be great if the the calculated field builder had a pre-built function so this kind of NULL replacement can be easily done with a couple of clicks.

Thank you!