Carly
Active Member
- Joined
- Aug 21, 2002
- Messages
- 370
I have a column which contains either "Stocked", "NonStocked" or "Sourced", another column containing either "Manual Review", "Repatriate" or "Clearance" and another column containing a sales value.
What I would like to so is SUM the sales value field when the 1st column contains "Stocked" & the 2nd column contains "Manaul Review"...Is there any way I can do this without creating a new field with a concatenated value.
Any help would be greatly received.
Regards
Carly
What I would like to so is SUM the sales value field when the 1st column contains "Stocked" & the 2nd column contains "Manaul Review"...Is there any way I can do this without creating a new field with a concatenated value.
Any help would be greatly received.
Regards
Carly