Forum Discussion

BobbyHollis's avatar
BobbyHollis
Qrew Member
4 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 product name at certain stages, got that figured out, but now I want a report that shows only those that changed. 

First stage field (text) I have memorialized is called Product @ PQ
Second stage field (text) I have memorialized is called Product @ CFC

Basically, want it to say 'If the Product @ PQ DOES NOT EQUAL Product @ CFC, "YES", "NO"

My attempt: 
IF (Contains([Product @ PQ],"SBA"), Contains([Product @ CFC], "Conventional"),"YES","NO"

screenshot of my error: 



------------------------------
Bobby Hollis
------------------------------
  • 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
    ------------------------------

7 Replies

  • 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
      Thank you for the quick reply! BINGO !

      I.feel.dumb. :) 

      Bh


      ------------------------------
      Bobby Hollis
      ------------------------------
    • BobbyHollis's avatar
      BobbyHollis
      Qrew Member
      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
        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
        ------------------------------