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")
Qrew Legend... 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!
