Formula assist

Hi,

I have 2 lists: 1) LIst of Funds (P3) and 2) List of Fund entities (P4) whose Parent is P3.

I also have a P3 details module that lists out the fund currency for P3 Funds.

My issue is, I have a module (P4) which I'm trying to pull the fund currency from the P3 details module - i've tried using PARENT(ITEM etc, but doesn't seem to work. Can someone please assist?

Thanks

Accepted answers

All comments

rob_marshall

@CommunityMember113484 ,

I believe you were on the right track, if I am understanding you correctly. In the module dimensionalized by P4, create a line item named P3 Link, formatted as P3, with the formula being parent(item of P4). In another line item, you will use a lookup to get to P3. So, if the line item in P3 is "data", your formula on the P4 module would be data[Lookup: 'P3 Link'].

Rob

CommunityMember113484

Hi Rob

Your explanation makes sense but I can't quite seem to get it!

I've tried: 'P3 Link' = PARENT('p4# Fund entities') with error: 'p4# Fund entities' is not a recognized line item or list member

Also tried: 'P3 Link' = PARENT(ITEM(('P4# Fund Entities'))

I've formatted to P3# Products, and applies to as well?

rob_marshall

@CommunityMember113484

On the P4 module, don't mess with the Applies To, that should still be the "-".

P3 Link = PARENT(Item('p4# Fund entities'))

Rob

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…