Input values based on a Boolean formatted Time Period

Options
CommunityMember88511
CommunityMember88511 Member, ALL USERS, Partner, Community Member Posts: 5 Contributor
in Planning & Modeling

 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

Tagged:

Comments

  • CommunityMember88511
    CommunityMember88511 Member, ALL USERS, Partner, Community Member Posts: 5 Contributor

    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.

     

     

Categories