Forum Discussion

SunakshiSethi's avatar
SunakshiSethi
Qrew Member
2 years ago

Do not include formula

Hello,

Need help with writing a report formula where the report not include specific supplier IDs. For example never to include ID # 123456 and #654321. 

Thanks



------------------------------
Sunakshi Sethi
------------------------------
654321.

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago

    Are you just talking about a filter on a report?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • SunakshiSethi's avatar
      SunakshiSethi
      Qrew Member
      2 years ago

      Hi, 

      Yes instead of using  the automated report filters, if I wanted to write a formula instead. 



      ------------------------------
      Sunakshi Sethi
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        2 years ago

        You can make a Formula Checkbox field.  if ID is a text field type, then

        [ID#]<> "123456"

         and #654321.

        #654321.



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------