I have an expression creating the value for a field however the result of that expression needs to stay above zero. I am subtracting the trade in value from the sale price of a vehicle. In the rare instance that the trade in value is higher than the sale price of the vehicle, I need the result to be 0 rather than a negative number. How can I complete this function?
Use the <-max->
operator
[Your expression]:<-max->0.
If your expression is negative, it will get shown as 0.
What would that look like in this expression?
Are you trying to only display the numerical result or do you actually want to display (X-Y)*.0625?
I imagine you just want to display the result, in which case you need to put everything in a single blue expression. After the first input’s value, use the minus “-” operator and put the second input’s value and then ‘*’… etc… and at the end of it all use the max operator.
You don’t need to use a math element to get this done, put the expression directly in the input.
I am looking to show the numerical result which I will then push to a field on a PDF file. Which box would I type this formula in on the input field?
The initial content