Null numerical values from Calculated fields

Nagarjun shared this idea 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.

I like this idea 0

Replies (4)

Dean Flinter ●

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

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

Reply URL

Chris McCarthy ●

Hi Nagarjun,

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

Kind regards,

Chris

Reply URL

Nagarjun ●

Hello Team,

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

Thank you so much.

Regards,

Nagarjun R

Reply URL

Chris McCarthy ●

Hi Nagarjun,

That's great to hear!

Enjoy your weekend!

Kind regards,

Chris

Reply URL