Set column to empty value with IF in initial value compute

[Minoas]

Hello,

I have a number column called X which gets a calculated initial value depending on what is selected in another field in the form.
IF([Other column] <> “”, [Price]/2.0, “”)

When [Other column] is empty X is set to be 0.00 euros, what I would like instead is to have X be set to empty, is there a value i can return from IF to achieve this?

[LeventK]

@Minoas
You can use this expression:

IF(ISNOTBLANK([Other column]), [Price]/2.0, NUMBER(""))

[Aleksi · Accepted solution]

Or like… IFS(ISNOTBLANK([Other column]), [Price]/2.0)

[Minoas]

Thank you both! Works perfectly!

Cheers