Discussions

Expand all | Collapse all

Add greater then in formula

  • 1.  Add greater then in formula

    Posted 11-29-2017 15:47
    I currently have the following formula:

    If([Return Needed] and [Installation] = "Self-Install",
      [Addon] + [New] + [Replace],
      [Addon] + [New] - [Removal]
    )

    What I would like to add in the "If" statement, another "AND", with [Numberfield] <30

    Kind of like this:

    If([Return Needed] and [Installation] = "Self-Install", and [Numberfield] <30,

    I tried different ways, and can't seem to get it.

    [Numberfield] is a numeric formula, that displays end results in a number.


  • 2.  RE: Add greater then in formula

    Posted 11-29-2017 15:50
    Remove the extra comma before the second and:

    If([Return Needed] and [Installation] = "Self-Install", and [Numberfield] <30,

    If([Return Needed] and [Installation] = "Self-Install" and [Numberfield] <30,


  • 3.  RE: Add greater then in formula

    Posted 11-29-2017 16:06
    Yes, that works. But after applying, I actually need that replaced with [Date] >30 days from today.
    [Date] is a date field