Forum Discussion

SunakshiSethi's avatar
SunakshiSethi
Qrew Member
3 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
------------------------------

3 Replies

    • SunakshiSethi's avatar
      SunakshiSethi
      Qrew Member
      3 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
        Icon for Qrew Legend rankQrew Legend
        3 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)
        [email protected]
        ------------------------------