on 01-05-2015 8:32 PM
Hi folks.
I am trying to use this count function to calculate number of lines within each PO but not getting the desired result. What is the best approach to this?
the fields are Vendor, PO, PO Line# ... using these I need to get the count of PO Line# at Vendor level.
sample data:
Vendor PO PO Line#
111 100 1
111 100 2
111 100 3
111 101 1
111 101 2
112 100 1
113 100 1
113 100 2
result should look like this:
Vendor Count
111 5
112 1
113 2
Thanks for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great. I had tried a different approach earlier but this works like a charm.
I can't unfortunately have the WHERE condition working on this formula. Please can anyone help?
This portion works fine ...
Count([Order No]+[Line No] In ([Vendor])
But not when using the WHERE operator .. I color coded the () for better clarity.
Count([Order No]+[Line No] In ([Vendor]) Where ([Days Past Delivery Date] > 90))
Thanks!
v_Count = Count([PO]+""+[PO Line#])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.