Skip to Content
avatar image
Former Member

Count calcuation


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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2015 at 06:30 AM

    Try this approach.


    Count.png (52.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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!

  • avatar image
    Former Member
    Jan 05, 2015 at 09:32 PM

    v_Count = Count([PO]+""+[PO Line#])

    Add comment
    10|10000 characters needed characters exceeded