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



      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.