- edited description
IF in DBRW can not work correctly
Issue #667
resolved
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
Comments (5)
-
reporter -
- changed status to open
Hi Ronan, we were able to replicate the issue and it has been added to our backlog.
-
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.
-
reporter Hi Stuart and Ada, Thanks.
-
- changed status to resolved
Fix is going to be included in the 2023.05 FP1 release.
- Log in to comment