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.