Replacing values in the Report with asterisk (*) based on a threshold

[Anonymous]

Hi All,

I am having a scenario which requires to replace the values in the report based on the following condition.

If the value falls below 10 then replace it with an asterisk (*).

Can anyone please help me to solve this problem. I can share more details if required.

Thanks

[Greg_Deckler]

The big issue you are going to have with this is that you are mixing text and numeric. Are you OK with everything being text?

If so, you could do something like:

Measure 9 = IF(SUM([Column1])<10,"*",CONCATENATE(SUM([Column1]),""))