How can I prevent negative numbers?

  • Profile Image
    jvanbergen
    Asked on January 06, 2017 at 07:23 PM

    I have built an overtime field that relies on daily hours. I thought there was an option for Greater Than but I can only find Equals and Not Equals. 

    Ideally, I would want the Daily Hours field to be ignored by the Overtime field if it is not Greater Than 8

     

    On another note, are their tiers of support when we move into subscription status?  

  • Profile Image
    EltonCris
    Answered on January 07, 2017 at 02:19 AM

    Hi,

    You can use the MAX math function e.g. max(0, result). This will turn negative numbers into 0.

    Example:

    Things to note: make sure the comma is not a text string (brown). It should be black to perform calculations.

    Hope this helps!