Input values based on a Boolean formatted Time Period

Hi Everyone,

I'm fairly new to Anaplan and currently self studying so please bear with me if this question seem basic.

Is there a way for me to use a boolean formatted line item to serve as a basis to what specific months I should put my computed values? The formula will go like this: IF first month of Month Picker (Boolean) >= Month Period of line item(Time-Period Month) THEN Values will be inputted from Month Period of line item up to the last month of the Month Picker ELSE 0.

Any help would be greatly appreciated. Thank you in advance

Accepted answers

VIGNESH.M

Hi @CommunityMember88511 ,

I am not sure that I understand your question completely.

My understanding is, the data should come only till certain month based on month picker(boolean) selection.

Try this,

I have picked below "MARCH" month, so the data is coming only till that month.

let me know, if I understood wrongly.

Regards,

Vignesh M

All comments

VIGNESH.M

Hi @CommunityMember88511 ,

I am not sure that I understand your question completely.

My understanding is, the data should come only till certain month based on month picker(boolean) selection.

Try this,

I have picked below "MARCH" month, so the data is coming only till that month.

let me know, if I understood wrongly.

Regards,

Vignesh M

rob_marshall

@CommunityMember88511

This is a safe place, any and all questions are welcomed whether you are brand new to Anaplan or a Master Anaplanner.

Rob

CommunityMember88511

Hi Sir @vignesh,

Thank you for the reply. I have applied a part of your solution. But instead of the formula in Month Picked, I made use of the ITEM(Time) formula to compare the time period to the boolean checker. Then I introduced an IF function to check if it is within the time period. Thank you for this!

@rob_marshall Thank you also. The community has been very helpful throughout my Anaplan experience.

xin

@VIGNESH.M

What is the TIME ALL PERIOD in line item Month Picked Final? I am struggling as how to remove the time dimension.

Thank you!

Quick Links

Can you help?

Unanswered questions

Count Unique Items Function
Hi, I have 2 lists, 1 is products and 2 is numbering - see screenshot. I have a module where it is dimensioned by product and the numbering and I want to count the number of unique values. Based on my screenshot, it should be 15. I saw there was a formula - isfirstoccurrence, but I'm not completely sure how to use this.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…