need help with a formula

[brendanbe]

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 has sales via the Online channel and also Sales via the Counter Channel.

                                             Sales Channel

Customer Name        Online               Counter

ABC                                   1M                       500K

DEF                                    2M                       300K

[Tahreem24]

Hi @brendanbe ,

Could you please also share the expected result?

[ZunzunUOC]

Hi @brendanbe , Which is the result that you want?

[brendanbe]

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]

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.

[Tahreem24]

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]

Hi @brendanbe ,

Please Mark this as a solution 🙂 .

[brendanbe]

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

[brendanbe]

hi @Tahreem24,

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

[Tahreem24]

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]

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.