Discussions

 View Only

  • 1.  Need two if conditions for a numeric formula

    Posted 08-05-2022 12:48
    I'm trying to make a numeric formula field that will only calculate a Total Invoice if the Override Points are blank (or zero) AND the Approved checkbox is checked (true).

    This part works
    If([Project Points Override]=0,
    [Project Points]*[Contract Coach - Current Rate],[Project Points Override]*[Contract Coach - Current Rate])

    When I try to add the checkbox=true it does not work. I'm sure I'm missing a syntax somewhere here
    If([Project Points Override]=0 & [Approved],true],
    [Project Points]*[Contract Coach - Current Rate],[Project Points Override]*[Contract Coach - Current Rate])

    It says the "=" can't be used on a type number. Any suggestions?

    ------------------------------
    Dawn Rene
    ------------------------------


  • 2.  RE: Need two if conditions for a numeric formula

    Posted 08-05-2022 13:21
    Try this:

    If([Project Points Override] = 0 and [Approved] = true,
    [Project Points]*[Contract Coach - Current Rate], [Project Points Override]*[Contract Coach - Current Rate])

    ------------------------------
    Ahuva Brown
    ------------------------------

    Original Message