Initial Value for a Ref Column

:thinking: so that is why I have been needing to do the if, because of the null. Will have to go in the DB and set some default values to CERO.

Okay - feel free to revoke my editor access.

The problem was your initial value was referencing the ‘Privado’ text instead of its paired key value of ‘0’. When dealing with REF columns, you have to target the parent / child records key column.

IF([Cubierto_por_ARSs],
  "",
  "0"
)

In the above, it is basically saying:

If [Cubierto_por_ARSs] is True, then leave the value blank, otherwise populate it with ‘0’ which is associated to ‘Privado’

2 Likes

Thank you very. I tried with the 0 and left it with ‘Privado’. You are awesome!

3 Likes