Hi
How do I limit the value based on Range of Dimension. Here is an example.
Say we have 3 branches ; Johannesburg, Durban and Cape Town and they all have a range of products codes which are alphabetical. All sales of these products are classified as Retail Sales. However products starting with K to N and sold only from Durban branch are classified as Independent Sales.
This is my formula but it does not work.
if(Branch = 'Durban' and Product >= 'K' and Product <='N', 'Independent Sales', 'Retail Sales')
Can you help
Many thanks
regards
Nayan