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
------------------------------
MarkShnier__You
Qrew Legend
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.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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.
------------------------------
John Crosland
------------------------------You can also user the Nz() function to force every number value to be treated as a 0 - its a good guaranteed catch that you don't have to worry about which values are null or which are treated as 0 to just make everything in the formula to be treated as 0 using Nz(). So Nz([Number Field]) > 0 will always work whether the value of Number field is null or 0.
------------------------------
Chayce Duncan
------------------------------
