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

Suggestions?

• ###### 1. Re: Partially Redacting Information via Calculation

The secret is probably to use a "table calculation function" such as WINDOW_SUM:

IF WINDOW_SUM(SUM([Number of Records])) >= [Minimum Number of Records] THEN 1 ELSE 0 END

1 of 1 people found this helpful
• ###### 2. Re: Partially Redacting Information via Calculation

Hi Kettan,

That looks pretty useful, but it isn't quite what I'm looking for. I specifically want to be able to replace the values under [Minimum Number of Records] with an a placeholder like "-" or "*" to indicate that there are values there, but that they are not shown as opposed to a null, which could either be no value or some values.

N

• ###### 3. Re: Partially Redacting Information via Calculation

Any chance you could share a packaged workbook with dummy data and a view that looks as close as possible to what you want to achieve?

This makes it much easier to help. Currently I am not sure I understand what you want to achieve, e.g. if the end result should be seen in a text table rather than a chart.

• ###### 4. Re: Re: Partially Redacting Information via Calculation

Here you are. My goal is to gain the benefits of the number formatting while also gaining the benefit of having the * in the text table. The end result for this purpose will be a a text table. '

Thanks!

• ###### 5. Re: Re: Re: Partially Redacting Information via Calculation

Hi Nicholas,

Thanks. This is very easy to understand. I am glad to say that it is possible to add another field with an asterisk which only has values when the other doesn't and thus only one field visible.

This is something I learned from a comment by  Jonathan Drummey.

See more details in attached workbook (and screenshot).

Jóhan a.k.a. Kettan

• ###### 6. Re: Re: Re: Partially Redacting Information via Calculation

Seems like as close as I'll get. Thanks!