2 Replies Latest reply on Aug 24, 2018 7:46 AM by Andy Paddle

    Blending Data results in True Null when trying to match 2 strings

    Andy Paddle

      Hi,

       

      I am having issue with Blending data and trying to create a calculation - The result is semi-correct but what I am looking for is to show actual words 'True' and 'False' instead what I get it is 'True' and 'Null'

      I don't also see an option to edit alias for Null nor under the Format option of the pill - I can only get 'True' to change to 'Yes' or 'On'

       

      Please let me know if there is any alternate way to show 'False' instead of 'Null'

       

      My calculation is:

      ATTR([Type]) = ATTR([Data1].[Type])

       

      Attached is a sample workbook with dummy data.