Formula Help Request
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 M...
Forum Discussion
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
------------------------------
Thank you!
------------------------------
Sheila Allas
------------------------------
