Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
3 years ago

Need two if conditions for a numeric formula

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
------------------------------
reports and charts
  • AhuvaBrown's avatar
    AhuvaBrown
    Qrew Cadet
    3 years ago
    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
    ------------------------------