Forum Discussion

lgs1983's avatar
lgs1983
Icon for Helper I rankHelper I
7 years ago
Solved

Cannot Convert value of type text to type true false

Hi,

 

I am getting increasingly frustrated with the above error message as I can't understand why it's appearing for the below formula as all fields involved are text.

 

Does anyone have any ideas where I'm going wrong?

 

Thanks in advance


    IF(
        LOOKUPVALUE(CIS[companyID],CIS[DUNSNUM],GUODataCombine[DUNS],CIS[CompanyName],GUODataCombine[PartyName]),
        "Found", 
        "Not Found"
    )
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    7 years ago

    Hi lgs1983 ,

    The test you are making is returning a text value, not a true false value. Now if you could frame it so that is Lookupvalue(CIS[CompanyID]) = x, then it can evaluate that. You will probably end up using  && for multiple tests, or you could try ISBLANK(). But your test needs something to evaluate.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

  • Nathaniel_C's avatar
    Nathaniel_C
    7 years ago

    Hi lgs1983 ,

    You may want to try ISBLANK()

    Checks whether a value is blank, and returns TRUE or FALSE. The function surrounds the value you are testing.

    However BLANK() returns a blank.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    Syntax

    DAXCopy
    ISBLANK(<value>)

    Parameters

    Term Definition
    valueThe value or expression you want to test.

    Return value

    A Boolean value of TRUE if the value is blank; otherwise FALSE.

4 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi lgs1983 ,

    The test you are making is returning a text value, not a true false value. Now if you could frame it so that is Lookupvalue(CIS[CompanyID]) = x, then it can evaluate that. You will probably end up using  && for multiple tests, or you could try ISBLANK(). But your test needs something to evaluate.

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

    • lgs1983's avatar
      lgs1983
      Icon for Helper I rankHelper I
      7 years ago

      Thanks Nathaniel_C , it was me taking it for granted it would see the lookup as a true or false automatically, now amended to the following and works:

       

          IF(
        LOOKUPVALUE(CIS[companyID],CIS[DUNSNUM],GUODataCombine[DUNS],CIS[CompanyName],GUODataCombine[PartyName]) = BLANK(),
        "Found",
        "Not Found")
    )
      • Nathaniel_C's avatar
        Nathaniel_C
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Hi lgs1983 ,

        You may want to try ISBLANK()

        Checks whether a value is blank, and returns TRUE or FALSE. The function surrounds the value you are testing.

        However BLANK() returns a blank.

         

        If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
        Nathaniel

        Syntax

        DAXCopy
        ISBLANK(<value>)

        Parameters

        Term Definition
        valueThe value or expression you want to test.

        Return value

        A Boolean value of TRUE if the value is blank; otherwise FALSE.