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

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
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…