Where clause in Member Filter Builder

[aricgresko]

Source:   Migrated from Champions

I’m trying to use the below member filter to remove only the intercompany accounts. This works, but I lose the indents from using Tree Descendants.

A#410000.TreeDescendants.Where(IsIC = False)

Is there a workaround to remove just the IC accounts while still retaining the indents from tree descendants?

[Bierenbroodspot · Accepted solution]

Yes, you can by going down level by level. Per level, you only include the members where the condition IsIC = False. Example:

A#410000.Children.Where(IsIC = False).Children.Where(IsIC = False).Children.Where(IsIC = False)…

[aricgresko]

Perfect - this is exactly what I was hoping for!

[ChristianW]

Can you mark @Bierenbroodspot ‘s reply as solution? Thanks