Set Analysis - One field equal but the other is not

[Anonymous]

Hey!

I want to create a set analysis that sums "Extended Cost" IF "Document Type" does not equal "Document Type" AND "Lot Number" EQUALS "Lot Number"

Please let me know your thoughts.

Thank you!

[sunny_talwar]

Document Type does not equal Document Type? Not sure I understand can you elaborate?

[Anonymous]

This is all one table.

IF two items have the same lot number and the document type does not match (i.e. one is "IF" the other "RM"), I want to sum the extended amount by lot number.

Make sense?

Document Type	Document Number	Batch	NDC number	Description	Lot number	Transaction Quantity	Unit Cost	Extended Amount	Gl Date
IF	6456	23432	2	ABC	4	-50	0.3401	-17.01	1/13/2014
RM	3234	658	1	CDE	5	10	0.22	15	1/13/2014

[swuehl]

In your sample, lot numbers differ. What do you want to do in this case?

Could you explain your requirements a bit more detailed?

What if Lot number is the same AND Document Type match? What if you have more than two records with different combinations of matching patterns?

[Anonymous]

I only want to include those where the Lot number match and the document type do not match.

[swuehl]

Maybe something like

Sum({<[Lot number] = {"=Count(Distinct [Document Type])>1"} >} [Extended Amount])