6 Replies Latest reply on Jan 2, 2014 11:10 AM by nicholas.richter

    Partially Redacting Information via Calculation

    nicholas.richter

      Hello all,

       

      I am trying to find a good way doing this, but so far I not finding the answer. I need to do a count of records and display them as usual as long there are more than 10 records. I've tried:

       

      IF sum([Number of Records]) < 10 THEN null ELSE sum([Number of Records]) END

       

      That works, but then there is no indication that an empty cell is actually a <10 cell. That isn't quite what I want.

       

      IF sum([Number of Records]) < 10 THEN "*" ELSE str(sum([Number of Records])) END

       

      That works too, but then the resulting value is a string, not a number. That creates a whole new set of problems (for example, I can't format the string as a number, so no commas for thousands).

       

      Suggestions?