Retrieve information from subsidiary view to use in a Boolean

Hi,

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.

Kind regards.

Accepted answers

Akhtar.shahbaz

Hi @CommunityMember117741

You can try this:

Hope this help!

Thanks

Akhtar

All comments

Akhtar.shahbaz

Hi @CommunityMember117741

If i understand your requirement correctly then you want to achieve your unassigned line item should be true for the list item that contain some value (4703866)

I am assuming your module have month dimension and just considering your last two line item,

Example:

As you seen in the formula have use lookup the year value.Create one system module for year selection or you can write the formula as well based on the current time setting.

Hope this helps!

Thanks

Akhtar

Panji

Hi @CommunityMember117741,

You can use YEARVALUE to convert YEAR to Month in line item boolean

Example

as you can see line item will be true if data FY19 not blank

And now you just need to read boolean if true then line item unsign will be get data form line item active

Thanks

CommunityMember117741

Hi,

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

Akhtar.shahbaz

Hi @CommunityMember117741

You can try this:

Hope this help!

Thanks

Akhtar

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…