Forum Discussion

BobbyHollis's avatar
BobbyHollis
Qrew Member
5 years ago
Solved

Help! This formula has to be simple, but it's not ... for me

Hey there, trying to make a formula field in a report that simply flags product names that changed at certain points of the funnel.  The fields referenced in my attempt are fields that capture the pro...
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    5 years ago
    Try this

    If([Product @ PQ] <> [Product @ CFC], "YES", "NO")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Try this

If([Product @ PQ] <> [Product @ CFC], "YES", "NO")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
BobbyHollis's avatar
BobbyHollis
Qrew Member
5 years ago
Hey Coach, 

still getting a YES even when Product @ CFC is null.  Being more forthcoming, I have 3 product stages I am trying to monitor here, so ideally something that flags a YES if:  Product @ PQ <> Product @ RFA OR Product @ RFA <> Product @ CFC 

tried this:
If([Product @ PQ] <> [Product @ RFA] OR [Product @ RFA] <> [Product @ CFC] "YES", "NO")

seems like QB doesn't use "OR" ...

Doable? 



------------------------------
Bobby Hollis
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    What's not working with your formula above.?  Looks right to me. 
    What if they are all blank.  What result do you want?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • BobbyHollis's avatar
      BobbyHollis
      Qrew Member
      5 years ago
      Thank you so much for your help Mark! I think I got it, played with it more last night:

      If([Product @ PQ] <> [Product @ RFA] or ([Product @ CFC] <> null and [Product @ PQ] <> [Product @ CFC]),"YES", "NO")

      this way when CFC field is blank it won't flag it :)

      ------------------------------
      Bobby Hollis
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        If those are text field types you may not use =null to test for blank.

         You need to test like..

        [my field] <> ""

         The documentation on the use of now clearly says that it does not work for text fields and by experience it does not work.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------