how can i shoe X

[ZachDev]

Hi

I have field that calculates percentages.

Sometimes a result of 253,444 %. 

I want it to display 900%+ in such a situation.

 how can i do it in analyze sheet/UI?

[Vegar]

Try this.

If ([DigitField]>900, dual('900+',900), [DigitField]) as [ModifiedDigit]

[ZachDev]

I explained it differently, Maybe now it will be clearer

[Vegar]

900% = 9

Try this

If( [PercentMeasure] >9, '900+', [PercentMeasure])

or maybe this will work as well

rangemin([PercentMeasure], dual('900+',900))