IF in DBRW can not work correctly

[Ronan Wang]

Seems like the custom cell’s default type is “String“, so comparing the value with a number will cause incorrect results.

the rightmost column is a custom cell, value is DBRW()

Added IF(DBRW() > 0, “Y“, “N“)

Then only “Y.

The feature is working correctly on the 2021.21.11 version

[Ada Trajer]

Hi Ronan, we were able to replicate the issue and it has been added to our backlog.

[srichardson]

Hi Ronan, I can fix this issue but for an immediate workaround try subtracting 0 from the DBRW function to convert the value to a number.

[Ronan Wang]

Hi Stuart and Ada, Thanks.

[Ada Trajer]

Fix is going to be included in the 2023.05 FP1 release.