Forum Discussion
Solved
Where clause in Member Filter Builder
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?
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)…
3 Replies
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)…
Perfect - this is exactly what I was hoping for!
ChristianWOneStream Employee
Can you mark Bierenbroodspot ‘s reply as solution? Thanks
