LOOKUP and FIRSTNONBLANK used in the same formula

CommunityMember129814

I have two modules in Anaplan:

• Module 1:
  Name: dat_Fund Composite
  Dimension (List): ad_Fund Composite ID
• Module 2:
  Name: dat_Segment
  Dimension (List): ad_Segment ID

There is no direct relationship or mapping between the two list dimensions.

I'm trying to understand how the following formula works:

Line Item: L0 Segment ID
Formula:

dat_Segment.'Create L0 Segment Code'[LOOKUP: Accounting Entity ID Lookup, FIRSTNONBLANK: dat_Segment.Lookup_Accounting Entity ID]

Could someone please explain how this formula functions?

Thanks in advance!

rob_marshall

@CommunityMember129814

That is essentially doing a SUM/Lookup which is very memory intensive, can cause performance issues, and is against best practices. Essentially, it is looking up the Accounting Entity (defined in the current module) to get the first non blank of L in dat_Segment. What is dat_Segment dimensionalized by?