Hello Everyone,
I am seeking to exclude certain data(items) from records (customers) that have purchased a number of our items...
The items sum up to a Total Gallons (purchased) and Total Sales $, based on date range of history invoice. However, there is some items that are not gallons and should not be included into the Total Gallons nor total sales.
Here is a list of item codes the need to be excluded or included which ever you guys think is easier...
|
EXCLUDE |
INCLUDE |
|
2EDI |
CAG |
|
2ELE |
CBG |
|
2EOE |
DAG |
|
2ESE |
EAG |
|
2ETE |
FAG |
|
2FRE |
GAG |
|
2HP |
GFG |
|
2LFT |
HFG |
|
2SUP |
LAG |
|
BLE |
MAE |
|
BSC |
MAG |
|
BST |
MBG |
|
CAE |
MFG |
|
CAL |
MIG |
|
CCE |
MMG |
|
CEQ |
OAE |
|
FCS |
OAG |
|
GAL |
OCE |
|
GCE |
OCG |
|
GFL |
OIE |
|
HFL |
OME |
|
LAL |
OMG |
|
MFE |
OTG |
|
MFL |
SAG |
|
MIE |
SCE |
|
MIL |
SLE |
|
MLE |
SME |
|
OAL |
SMG |
|
OTE |
SML |
|
PCE |
VAG |
|
VAE |
|
|
VAL |
|
|
VFE |
|
|
VLE |
|
Basically, what I need to know, is where should I include this to propogate this? or where should I create this formula?
Please help me out with this... My JOB depends on this
...
Thank you,
IP Logged
