When edit a row every formula return zero but I need blank

AppSheet AppSheet Q&A
1

Some columns has this formula, the column type is decimal

IF(
    AND(ISNOTBLANK([Porcentaje EP3]), ISNOTBLANK([Valor])),
    [Porcentaje EP3] * [Valor],
   ' '
)

When editing a row, this formula returns zero, but I need it to return a blank cell instead of zero.

thanks

2

Try this:

IF(
    AND(ISNOTBLANK([Porcentaje EP3]), ISNOTBLANK([Valor])),
    [Porcentaje EP3] * [Valor],
   DECIMAL("")
)

or this:

IFS(
    AND(ISNOTBLANK([Porcentaje EP3]), ISNOTBLANK([Valor])),
    [Porcentaje EP3] * [Valor]
)