3 Replies Latest reply on Sep 6, 2018 1:16 PM by Shinichiro Murakami

    Using If Statement inside LOD

    Abu Tableau

      Hi Team,

       

      Need your help in making a formula where I have to count number of records for individual ID's.

       

      {FIXED [Fact  Id]:max([Number of Records])}

       

      But from Database I got several Fact_ID as either NULL or (-1). I would like to exclude Null/(-1) ID values and then use this LOD expression. Kindly guide me through in this scenario.

       

      Thanks,

      Masood.