Forum Discussion

damilolaA's avatar
damilolaA
Regular Visitor
1 year ago
Solved

If Statement Calculated Column Returning Incorrectly

Hello everyone,    Can someone please explain why the calculated column returns false instead of blank when the qty is between 4 and 7? Thank you.   
  • djurecic's avatar
    djurecic
    11 months ago

    Also, blank= false when converting data type from text to true/false.

    So if you have this:

    then convert the data type to true/false, everything is false:

     

djurecic's avatar
djurecic
Icon for Super User rankSuper User
11 months ago

Ok, I think this is happening because you are trying to combine Blank() and False().

Below are some options that will work:

 

 

 

 

 

damilolaA's avatar
damilolaA
Regular Visitor
11 months ago

Thank you. Do you have any idea why we can't combine BLANK() and FALSE()?

  • djurecic's avatar
    djurecic
    Icon for Super User rankSuper User
    11 months ago

    They are different data types.

     

    True/False is binary and can only have 1 of 2 values.

     

    If you really need the value to be false, you can try using "False" as a text value.