Skip to main content
Question

Need two if conditions for a numeric formula

  • Aug 5, 2022 4:48 PM UTC
  • 0 replies
  • 52 views

Forum|alt.badge.img+5
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
------------------------------
This topic has been closed for replies.

  • Observing
  • Aug 5, 2022 5:21 PM UTC
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
------------------------------