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

    Partially Redacting Information via Calculation


      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).