Skip to main content
Question

Formula Help Request

  • Oct 11, 2023 2:43 AM UTC
  • 0 replies
  • 96 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.

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
------------------------------