GarryFreeman
New Member
- Joined
- Apr 17, 2020
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Good Afternoon.
I am hoping someone can help me with the below.
I am running a report that shows sales by item number which I then need to group as categories as in G3 below. However if a credit is raised it does not reference a item number (B2)
What I am trying to achieve is if C2 is a negative then it returns "Credit" and if it has a sku number then it returns a category such as Brand A from the array table, and if the SKU number is not in the table array then returns "B2B"
Is this at all possible?
Many Thanks in advance
Garry
I am hoping someone can help me with the below.
I am running a report that shows sales by item number which I then need to group as categories as in G3 below. However if a credit is raised it does not reference a item number (B2)
What I am trying to achieve is if C2 is a negative then it returns "Credit" and if it has a sku number then it returns a category such as Brand A from the array table, and if the SKU number is not in the table array then returns "B2B"
Is this at all possible?
Many Thanks in advance
Garry