Parent / Child - Formula

Hi Community,

We're stuck on a formula and not sure if it is remotely possible in the first place.

Can a Boolean be TRUE for the Parent but FALSE for all the children?

To give some background:

In a Planning model on Dynamic Time (lists, not native time) we have Week - Day hierarchy.

On the dashboard there's a 52 Weeks input Boolean to select which weeks you want to see in Days.

When the Week is selected, a Boolean on the Day format looks up the value of the Parent and will then be TRUE for all the children. Showing all the days in the selected weeks.

The requirement has changed however that they want this functionality, but for the Weeks that are not selected the Week should still be shown but not in Days, thus the parent.

Hope this is explained well enough.

Thanks to the brave for taking a jab at this!

Accepted answers

All comments

prabhu

Hi @HendrikDeCuyper ,

You can use NOT function

Formula is = NOT WEEKVALUE(Module AA.Check)

Let me know if it address your problem.

HendrikDeCuyper

Hi,

Thank you for trying! Unfortunately, this does not solve the problem.

I'm aware of the NOT function, the result should be that the value for the Parent (Week) is TRUE and for the Children for that Week (Days) is FALSE.

Hope somebody can help.

prabhu

@HendrikDeCuyper - In my previous post,

i set parent week (Week 1 FY20) as True
in my result module(Module BB), child(1,2, 3 Jan 20) for Week 1 FY20 are all False

Your Previous Post -

"I'm aware of the NOT function, the result should be that the value for the Parent (Week) is TRUE and for the Children for that Week (Days) is FALSE."

I didn't understand what you mean, Can you give some example.

nathan_rudman

I'm not very clear on what you want, especially what you mean by a week to be selected.

However, it is possible to have a different value, and formula, for the parent / child.

First, you have to change the summary type to formula (which means you cannot have a LOOKUP in that formula).

Then you need to find a way to detect if you are on the parent or a child. The most commonly used method is a boolean LI you can call "low level" set to TRUE with none as summary type. You can then use this line item to control your formula:

IF low level THEN "this is the child" ELSE "this is the PARENT"

If you need a LOOKUP, you can have a specific line item with the value you want and reference it in the formula above.

kathleenseiler

I would do something like this, I believe the Final Filter line item at the end here is what you're looking for. What I did was use 'Ratio' to get the parent level of Week to have a '1' in it even if the Week was not selected. See below for the blueprint.

NOTE the applies to on 'Technical' is blank.

The Ratio on Level 1 is Technical / Technical. The Ratio on Level 2 is Level 1 / Technical.

Hope this helps!

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
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…