JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Using Calculations To Show If A Number Is Negative Or Positive?Asked by StudioBe on January 23, 2014 at 11:59 AM
I am trying to create a goal sheet from my employees to use at the end of the night to calculate if they were over or under their sales goals for the day. Right now its pretty simple... They put in their sales goal in one field and their actual sales amount in the next. From there, I don’t know how to make the form decipher between over goal or short. Any suggestions? Maybe something with conditions? Thanks!!
That can be accomplished by using conditions. However, you need to determine an specified number for the field Actual Sales, in that case you will not need to use the Calculation feature.
Please take a look at this form: http://form.jotformpro.com/form/40224325810947
If the Actual Sales is less than 100m, then it will show "Under Goal". But if Actual Sales is greater than 100, it will show "Over Goal". These are the conditions I created:
To accomplish that I used the Text tool to create the texts Under/Over Goal.
I hope this helps. Please inform us if you need further assistance with this inquiry.
My problem is that the goal changes every day. If I already have a field that calculates over / short of goal, can I use that field? i.e. If "Over / Short Field" is more than "0" then send this email. If "Over / Short Field" is less than "0" then send this email. Would that work?
Yes, that is possible. The condition should be like this:
Here's a theoretical demo: