Retrieve information from subsidiary view to use in a Boolean
I need to retrieve information from a subsidiary view and use in logic in another Boolean formatted line item.
I want to see which account is unassigned during a given point in time. I already had a subsidiary this by month.
I needed to see it with a yearly time scale as well so I created the view below with time scale yearly.
What need help with is to add logic to my Boolean "Unassigned', to be TRUE for an account if the yearly subsidiary view is not blank for said account. The Boolean has no time scale (not applicable). In the example my Boolean should be TRUE for account 4703866. However, I cannot find a way to use the information in the subsidiary yearly view for my Boolean that will not have a time scale, and that is why I am hoping someone here can help me.