Hi guys,
I have created a composite key in which I combines two fields. The distinct value of the count of this should be the resultant figures in a table. However, in addition to this I want to add s signage onto it, marking whether this is coming into or out of the company. Can anyone this of a way in which to do this?
For example 1 key could be 45648684UAT which is coming into the company which would be positive.
Example 2, 1 key could be 71246846ABC which is moving out of the company which should be negative.
I want to use a sign_map I have created to multiply the key by the sign (+/-ve). Then when I do the count I will have positive and negative counts which is what I am looking for.