Formula to Test for Percentage Value

[Henry_Scott]

I have a PERCENT Column and in my form, I want to do checks to see if the Percentage value is 100% or greater

I have tried the following and it returns N
[Order Percentage Complete]>=100.00
NUMBER([Order Percentage Complete])>=100

How do I check that [Order Percentage Complete] which is a PERCENT Column is 100% or greater

[Suvrutt_Gurjar]

Hi @Henry_Scott,
Could you please try an expression something like below in the VC

IF([Order Percentage Complete]>=1.00, “Exceeds 99 %”,“Within 99%”)

If you are having expression in the Valid_if or other constraint columns it could be something like
[_THIS]>=1.00 or [_THIS]<1.00

I quickly modified the sample Pie Chart sample app by adding VC for computing the percentage expression as above and it works as follows.

The original Pie Chart sample app is at
https://www.appsheet.com/samples/How-to-make-a-pie-chart?appGuidString=f1f26085-cfa6-4363-905f-4313e...
The table view image of my quick testing with above app formula is below

Hope this helps

[Henry_Scott]

Suvrutt_Gurjar:

[Order Percentage Complete]>=1.00

Thank you. the test for 1.00 solved my querie

[bokhara_applica]

Hi
I have a problem to find a percentage solution according to choosing the type of fonts, for example, a person entered 8
The rate is 4% * price \ 100 and in the case of H1 the rate is 3% * price \ 100 and in the case of no the ratio is 2% * price \ 100
I want how to write on AppSheet