Do not include formula

Question

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.&nbsp;
Thanks------------------------------Sunakshi Sethi------------------------------

markshnier__you · Answer

Are you just talking about a filter on a report?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

sunakshisethi · Answer

Hi,&nbsp;

Yes instead of using&nbsp; the automated report filters, if I wanted to write a formula instead.&nbsp;------------------------------Sunakshi Sethi------------------------------

markshnier__you · Answer

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

[ID#]&lt;&gt; "123456"
&nbsp;and&nbsp;#654321.
#654321. ------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Do not include formula

3 Replies

Related Content

Report Formula - Combine some, exclude some, and include others.

QrewTip: Formula Logic Order

Assistance Needed to Locate Formula Fields which include Specific String

Code Page Formula Button

Formula to calculate hours