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

Just checking- is Qty datatype text?

  • damilolaA's avatar
    damilolaA
    Regular Visitor
    10 months ago

    It was already formatted as a  whole number in Power Query