Retrieve information from subsidiary view to use in a Boolean

Options
CommunityMember117741
CommunityMember117741 Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Contributor
in Extensibility

Hi, 

 

I need to retrieve information from a subsidiary view and use in logic in another Boolean formatted line item. 

CommunityMember117741_0-1586205613074.png

CommunityMember117741_1-1586234212099.png

 

I want to see which account is unassigned during a given point in time. I already had a subsidiary this by month. 

CommunityMember117741_1-1586205753639.png

I needed to see it with a yearly time scale as well so I created the view below with time scale yearly.

 

CommunityMember117741_2-1586205869287.png

 

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. 

 

Kind regards. 

 

Tagged:

Comments

  • CommunityMember117741
    CommunityMember117741 Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Contributor

    Hi, 

     

    Thank you for you answer. My Boolean is has no time scale. It has line items in columns and list in rows. 

    CommunityMember117741_0-1586234781340.png

     

Categories