Hi,
I need to show when a price differences from ech other.
See below i have;
Number Price
463.40.008 79.00
463.40.008 79.00
463.40.008 79.00
463.40.009 79.00
463.40.009 109.95
463.40.009 79.00
463.40.009 79.00
463.40.083 39.00
463.40.083 35.00
463.40.013 79.00
463.40.013 79.00
463.40.013 79.00
So the numbers that i want for result are the numbers with "price difference".
From example above the result should be;
463.40.009
463.40.083
Help would be appreciated.
Solved! Go to Solution.
Hi @Sooco
I have used two unique tool. One on your price field and then another on the number field to give you what you have below.
In my example I get three instances where the prices differ, because your logic below assumes 79:00 is standard and is therefore not included. If this is the case, you can just use a filter tool and say [Price]!=79.00 and then use the unique technique in the attached workflow.
Workflow build in V:10.6
Best,
Jordan Barker
Solutions Consultant
Hi JordanB,
The problem is it are several thousend numbers.
Sometimes 1 number has 5 prices (different or not different), sometimes 2 prices (different or not different)
So i cannot use "fixed" filters because the prices veray for each number. In my example i mayby used to much 79.00.. :)
So i only want to see the numbers where prices are different from the same number.