Forum Discussion

SheilaAllas's avatar
SheilaAllas
Qrew Trainee
8 months ago

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

5 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew 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
      ------------------------------
      • JohnCrosland's avatar
        JohnCrosland
        Qrew Trainee

        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
        ------------------------------
    • SheilaAllas's avatar
      SheilaAllas
      Qrew Trainee

      Thank you!



      ------------------------------
      Sheila Allas
      ------------------------------