Forum Discussion

damilolaA's avatar
damilolaA
Regular Visitor
10 months 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
    10 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
10 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
10 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
    10 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.