Using Calculations To Show If A Number Is Negative Or Positive?

  • Profile Image
    Asked 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!!

  • Profile Image
    Answered on January 23, 2014 at 01:03 PM

    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:

    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.


  • Profile Image
    Answered on January 23, 2014 at 02:25 PM

    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?

  • Profile Image
    Answered on January 23, 2014 at 03:26 PM

    Yes, that is possible. The condition should be like this:

    Here's a theoretical demo: