topic Re: If Statement in App Development

If Statement

evansabres — Thu, 22 Aug 2019 13:28:52 GMT

I am trying to create an IF statement as an expression. I have an expression titled 'Remaining Capacity %'

I want to create an IF Statement that says, IF([Remaining Capacity %]) <= 20%, $10)

I cannot seem to get the format of the expression correct.

Re: If Statement

trdandamudi — Thu, 22 Aug 2019 13:51:29 GMT

How about the below expression:

IF( [Remaining Capacity %] <= 20%, $10 )

Re: If Statement

evansabres — Thu, 22 Aug 2019 13:54:14 GMT

I tried that, as well as placing the 20% in quotes. I was attempting to pass through the name of the expression instead of using the full equation, however I can use that method for the time being. Thanks for your help.

Re: If Statement

trdandamudi — Thu, 22 Aug 2019 14:02:19 GMT

How does the value looks like in the field [Remaining Capacity %] ? Can you share few values ?

Re: If Statement

evansabres — Thu, 22 Aug 2019 14:06:32 GMT

The output is a percentage. The expression behind Remaining Capacity % is =(([Remaining Capacity])/([plCAP]))

Re: If Statement

trdandamudi — Thu, 22 Aug 2019 14:11:45 GMT

Use the below expression:

if([Remaining Capacity %] <='20%',10)

And then to show the '$' before 10, go to "Number" tab and select "Money"