[Spring'20] The VALUE() function behavior differ Winter'20 and Spring'20
Last updated 2021-10-12 ·Reference W-7114667 ·Reported By 7 users
Summary
When we use the VALUE() function on the formula field, the behavior differ Winter'20 and Spring'20.
Suppose we create the following formula. This return value type is checkbox.
---
IF(OR(VALUE(Text__c)>=1,ISBLANK(Text__c)),true,false)
---
In Winter'20, when Text__c value is null, the formula return value display "true" in the List view and record detail page.
This is the same behavior in Classic and Lightning.
In Spring'20, when Text__c value is null, the behavior is differ Classic and Lightning.
Classic: The formula return value display "true" in the record detail page.
In the List view, returns "#Error!".
Lightning: The formula return value display "false" in the record detail page.
In the List view, returns "false".
Repro
1)Login to org.
2) Switch to Lightning.
3) Create custom text and formula fields in any object.
ex)
-----
[Lead Object]
- Field Label: Text
API Name: Text__c
Data Type: Text
- Field Label: Formula
API Name: Formula__c
Data Type: Formula(Checkbox)
IF(OR(VALUE(Text__c)>=1,ISBLANK(Text__c)),true,false)
4) Create Lead record. Leave Text field as blank.
ex)
-----
LEAD TEST001
5) Go to "LEAD TEST001" record detail page. The formula return value display "false".
6) Go to "View - Custom1" list view, and add "Formula" field to this list view. The formula return value display "false".
7) Switch to Classic.
8) Go to "LEAD TEST001" record detail page. The formula return value display "true".
9) Go to "View - Custom1" list view. The formula return value display "#Error!".
Workaround
none
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.