Skip to Content
avatar image
Former Member

Counting Specific Unit

Hello all,

I am working off of my original post (https://answers.sap.com/questions/182286/multiple-lines.html)

In this post I created a formula to pull together when a certain field, "Unit Names" had more than 1 entry. This is working perfectly thanks to the experts here, however I am trying to do a count for each unit. When I do so my formula is not counting the unit if it is listed with other units. My current formula is

If {DUE_DIL_MASTER_VW.UNIT_NAME} = ("Martin Unit A") and {DD_TRACKING.ABS_STATUS} = "Open" then 1 else 0

I tried putting % in front of and after "%Martin Unit A%" this does not work, I also replaced the = and made it "Like" but still not working.

As always the help is greatly appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 24, 2017 at 04:05 PM

    Hi Matt,

    Does this work:

    If {DUE_DIL_MASTER_VW.UNIT_NAME} LIKE "*Martin Unit A*" and {DD_TRACKING.ABS_STATUS} = "Open" then 1 else 0

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded