@PaulWestonVA the only way to remove the parents from the list is to create a flat list of children. You can still use the techniques listed above for dependent drop downs, Once chosen, you can then match the flat list against the hierarchical list if needed I hope this helps David
... View more
not entirely elegant but....you'll need to use a "signal row" = if number row <> 0 then 1 else 0….next add calc row that divides ‘number row’ by "signal row" (the count)…and in blueprint mode change the calc row from sum to ‘formula’. See attached pictures
... View more
