Forum Discussion

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...

New Member

7 years ago

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

Super User

7 years ago

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

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

brendanbe
New Member
7 years ago
hi Tahreem24,

yes i think something like that could work. if it could be text even better.
- Tahreem24
  Super 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.
  - brendanbe
    New Member
    7 years ago
    hi Tahreem24 ,
    
    that should be ok, if the customer has -1 i want to be able to hide those customers so they dont show in my table anyway.
Tahreem24
Super 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
  Super User
  7 years ago
  Hi brendanbe ,
  
  Please Mark this as a solution :) .
  - brendanbe
    New Member
    7 years ago
    hi Tahreem24 ,
    
    its not working for my scenario case. below is an exmaple of my matrix table.
    the B2B ORDER is equilavent to Online Sales and Counter Sales is further to the right on the scroll bar.
    my data is also loaded from a SQL database and my sales channel is a Measured column in itself

Related content