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.
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")
... and if those are summary fields for the scores, be sure that the field properties are marked as do not treat blank as zero.
Good catch Mark!
If it is a field that is treated as 0, then you could change the formula to be Score>0
That way it doesn't have potential impacts in other parts of your app.
Thank you!
