Skip to main content
Question

Formula Help Request

  • October 11, 2023
  • 0 replies
  • 59 views
Forum|alt.badge.img+4

I have 3 different fields that I need to incorporate into a formula to determine if the record qualifies to be on a variance report.

# of Reviews for the Month - must be 5 or more

Score - Prior Month - must not be null

Score - Current Month - must not be null

Nothing I try seems to work for this scenario.  I'd appreciate any advise.



------------------------------
Thanks,
Sheila Allas
------------------------------
      This topic has been closed for replies.

      • JohnCrosland
      • Registered
      • October 11, 2023

      Here you go. Just change the fields to be your actual field, and you can make it a checkbox by removing the if and the variance part at the end of the if statement.

      If([# of Reviews for the Month]>4 and not(isNull([Score - Prior Month])) and not(isNull([Score - Current Month])), "Variance")



      ------------------------------
      John Crosland
      ------------------------------
        Terms & ConditionsAccessibility statement