Forum Discussion

brendanbe's avatar
brendanbe
New Member
7 years ago

need help with a formula

Hi All,   wondering if someone would be able to help me with a solution to this problem i am having. i have a sales table bit like the below and im looking for a way to call out if the customer ha...
Need Help
ZunzunUOC's avatar
ZunzunUOC
Resolver III
7 years ago

Hi brendanbe , Which is the result that you want?

  • brendanbe's avatar
    brendanbe
    New Member
    7 years ago

    hi ZunzunUOC ,

     

    looking for something like when the customer has sales via the online channel and also over the counter that in a new column i can call them out as needing a call from me vs if the only have sales via online i dont need to call them.

    hope that makes sense

    • Tahreem24's avatar
      Tahreem24
      Super User
      7 years ago

      Hi brendanbe ,

       

      Please let me know you wanted something like "Result Column" in attached screen shot? 

      "-1" indicate that Customer has sales in either channel.

      • brendanbe's avatar
        brendanbe
        New Member
        7 years ago

        hi Tahreem24,

         

        yes i think something like that could work. if it could be text even better.