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
Icon for Resolver III rankResolver 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
    Icon for Super User rankSuper 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.

      • Tahreem24's avatar
        Tahreem24
        Icon for Super User rankSuper User
        7 years ago

        Hi brendanbe ,

         

        It's not possible to use Number and text values in a single column. That's why instead of text I marked the value as "-1" for those customers who is having sales in either channel.

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      7 years ago

      Hi brendanbe,

       

      Yeah, You can filter out those "-1" values. Please use the below calculation for your expected result.  And mark this answer as a solution :).

      I hope I answered  your question.

       

      • Tahreem24's avatar
        Tahreem24
        Icon for Super User rankSuper User
        7 years ago

        Hi brendanbe ,

         

        Please Mark this as a solution :) .