topic how can i shoe X in App Development

how can i shoe X

ZachDev — Sun, 11 Dec 2022 12:20:11 GMT

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 — Sun, 11 Dec 2022 09:45:46 GMT

Try this.

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

ZachDev — Sun, 11 Dec 2022 13:18:29 GMT

I explained it differently, Maybe now it will be clearer

Vegar — Mon, 12 Dec 2022 05:57:42 GMT

900% = 9

Try this

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

or maybe this will work as well

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