Applying a TRUE boolean across all months when a single month is TRUE

Hello,

I have a module with three relevant dimensions:

Position ID (FLAT Position ID)

Component (FLAT Components)

Time (monthly)

For a component under a position, if any month is marked true in an initial line item, every month should be marked true in an associated line item. Screenshot attached, but in the example if TBR for BELL is marked TRUE in JAN 21, I want to mark every month as TRUE in the next line item.

I have tried using an interim line item that removes the time dimension and then trying to pull it back up using an ANY, but this isn't working.

Any suggestions would be appreciated. Thank you

Delta_screenshot2_88665.PNG

Delta_screenshot1_88665.PNG

Accepted answers

anirudh

One last change, sorry for missing it earlier.
Change Position Delta Flag formula to:
Delta Flag[SELECT: Time.All Periods]

All comments

anirudh

You're on the right track and it's a quick fix!
Just go to the Delta Flag line item in blueprint view and change the time summary level to Any

Then change the Final Delta Flag formula to simply refer Position:Delta Flag

Regards,
Anirudh

RobinSilk

Thanks for your response, unfortunately it isn't working. I've tried changing delta to time summary of any, to no avail. Here are screenshots of how the module + blue print look. Delta Flag and Final Delta Flag are both set to "None, Time: Any"

1_88668.PNG

2_88668.PNG

anirudh

Hey Robin,

Could you change Position: Delta Flag to simply refer Delta Flag and the final Delta Flag to refer Position: Delta Flag, no ANY formulas on any of the line items

RobinSilk

Done as you asked, more screenshots below. Still not flowing as expected.

4_88675.PNG

3_88675.PNG

anirudh

One last change, sorry for missing it earlier.
Change Position Delta Flag formula to:
Delta Flag[SELECT: Time.All Periods]

ArnavParmar

Hey, were you able to solve this problem ?

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…