Null numerical values from Calculated fields

Nagarjun shared this idea 3 months ago
Completed

Add an option so that the numeric typed answer from a calculated field can be a null value.

We are trying to create a calculated field (case when columnA = 0 then NULL else SUM(columnA) end). we could able to give the same formula on the DB but not on yellowfin.

Comments (4)

photo
3

One way we got around this was to create a virtual table in the view with a null value cast as a number. You can then reference this in the formula builder

Something like this

SELECT
id,
CAST(null as number(9,2)) as null_column
FROM my_table

photo
1

Hi Nagarjun,

Just checking in, were you able to make use of the suggested solution mentioned above?

Kind regards,

Chris

photo
1

Hello Team,

Sorry, I've missed updating my response here, it is working as expected.


Thank you so much.

Regards,

Nagarjun R

photo
1

Hi Nagarjun,

That's great to hear!

Enjoy your weekend!

Kind regards,

Chris