3 Replies Latest reply on Sep 12, 2018 3:49 PM by Okechukwu Ossai

    Visual Table Tracking Existence

    Jonathan Hodge

      Howdy all!

       

      Title may be a bit confusing but had a request for ideally a simple yes/no table. Yes if the column/row exists, no if not.

      In that snippet, if there is ever an Abc then it should say "Yes". If it is blank then it should say "No".

      I thought about using [Number of Records] and some form of calculation saying "if >= 1 then Yes, else No".

      The issue I have is that those blanks are not nulls but rather never exist at all in the dataset.

       

      Is there a solution by chance? have attached sample workbook.

       

      Thanks!