3 Replies Latest reply on Aug 30, 2018 4:01 AM by Ken Flerlage

    Display a string when countd under a certain value

    Beth Bambrick

      I'm trying to figure out a way to display a string when the value of a count distinct expression is under a certain value. For example, I am counting distinct ID numbers in a region associated with aggregated demographics. To preserve some level of confidentiality, I only want to display counts of individuals when there are more than 5 in a region.


      I'm essentially trying to do this calculation, but cannot do so because it tries to compare a value to a string.


      If CountD(ID) >5 then CountD(ID) else '<5" end


      Any suggestions on how I might accomplish this?