Skip to Content
0

Counting Specific Unit

Apr 24, 2017 at 03:34 PM

26

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Abhilash Kumar
Apr 24, 2017 at 04:05 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I did this with % instead of *, thank you for the help.

0