Skip to Content
0
Nov 08, 2018 at 05:44 PM

Udf help required for the counting subline items

118 Views

I have line items and subline items in the same context as below. All are in same context

0001
0002
000201
000202
000203
0005
000501
000502
i need to count subline items for each main line item
ex
first line item 0001 has no sub line items so i should set N to target
second main line item has three subline line items so it should set to Y
subline items 000201,000202,000501 all set to blank.
if any main line item has 0 or 1 subline items we should set to N else Y

all subline items length will always 6 and main line items length 4
Thanks for your help