Anaplan Community

Frank Calderoni's 2020 Vision: The Future of Anaplan is Clear

Our latest Ask Me Anything session is now live! Anaplan CEO Frank Calderoni talks about the future of the Anaplan platform and answers your questions in an exclusive week-long Ask Me Anything event. ...

Jump-Start Your Center of Excellence with a Model Building Standards Document

As more organizations embrace Anaplan as their cloud-based platform for business planning, many are looking to establish an internal Anaplan Center of Excellence to support their growing footprint. H...

Announcing The Master Anaplanner Program 2020 Maintenance Requirements

The Master Anaplanner Program formally launched maintenance requirements, effective calendar year 2020. Participation is required to retain Certified Master Anaplanner status for calendar year 2021.

SFDC Lightning Migration

Migrating from the classic SFDC platform to the Lightning platform can create issues with some Anaplan models. This article covers issues with SFDC objects and the steps to correct them.

Meet our 2020 Community Bosses!

Announcing the 2020 Community Boss lineup! This program recognizes customers, partners, and employees who go above and beyond in the Community.

New Year Tips for Anaplan Project Success

Here are four tips for project success in 2020! Learn how to motivate teams, encourage innovation, and create a culture of open communication.

Centers of Excellence

Search the Anaplan Community

Find answers, share solutions, and connect with Anaplan users and planning thought leaders from around the world.

‹

Re: Join/append 2 Lists

Hi @MarkT83 The modification i suggest below assumes you're inserting 'Customer' and 'Fake Time' manually in the model. If you're loading 'Customer' and 'Fake Time' from Data Hub or vi...

Hi @MarkT83 The modification i suggest below assumes you're inserting 'Customer' and...

Re: Yearvalue Function

@anupkumar.gade Just adding to what @rob_marshall had to say.You discovered something that isn't documented so it opens up the opportunity to think about use cases.I typically work in t...

@anupkumar.gade Just adding to what @rob_marshall had to say.You discovered something...

Re: Join/append 2 Lists

Thanks @LipChean_Soh for the detailed response, it works quite well The main issue I was having trouble with was creating a method whereby the Customer/Fake Time list could be updated ...

Thanks @LipChean_Soh for the detailed response, it works quite well The main issue I...

Re: Yearvalue Function

@anupkumar.gade , If you have any month as a True, with ANY as a summary it will be true as @Jared Dolich stated. Why would you use this? Again, checking to see if anyt...

@anupkumar.gade , If you have any month as a True, with ANY as a summary it will be true a...

Re: Yearvalue Function

Thanks @Jared Dolich But still, what would be the relevance of using the YEARVALUE function in a boolean format?

Thanks @Jared Dolich But still, what would be the relevance of using the YEARVALUE functio...

Re: Join/append 2 Lists

Hi @Asslam As you can see from the 'Example of Joined List' provided by @MarkT83 , the member in the 3rd list is either from the 1st list OR from the 2nd list. Unless i'...

Hi @Asslam As you can see from the 'Example of Joined List' provided by @MarkT8...

Re: Yearvalue Function

@anupkumar.gade What an interesting discovery!I tested this myself and it works as you suggest. I did have to change the summary to "ANY" in order to get the yearvalue though.I guess in my mind t...

@anupkumar.gade What an interesting discovery!I tested this myself and it works as you suggest....

Yearvalue Function

SyntaxYEARVALUE(x)where:x: Source line item or property to be summarized.FormatInput Format Output Formatx: NumberNumber As from above we can see input & output format should be number for YE...

SyntaxYEARVALUE(x)where:x: Source line item or property to be summarized.FormatInput Format Output F...

Re: Ability To Automate The Multiple Line Option Within Text Formatted Line Item

@Saksham.Bansal , The only work around we have used is using the excel plugin, where you could create a view for the user and in excel you should be able to do all sorts of text formatting to the...

@Saksham.Bansal , The only work around we have used is using the excel plugin, where you could ...

Re: Join/append 2 Lists

@LipChean_Soh , good explanation. Also will it help in the third list (composite list) to have all the customer as parent and adding the required fake time as child. In this way you could still g...

@LipChean_Soh , good explanation. Also will it help in the third list (composite list) to have ...

›

Community Activity

29077

Members

420

Users Online

16207

Total Posts

Featured Content

Announcing The Master Anaplanner Program 2020 Maintenance Requirements

The Master Anaplanner Program formally launched maintenance requirements, effective calendar year 2020. Participation is required to retain Certified Master Anaplanner status for calendar year 2021. Read Full Article

Partner Planning Perspectives: Holiday Edition

It's that time of year again—time to reflect, adjust, and plan! Partners share their personal and professional planning tips for a happy holiday and prosperous new year. Read Full Article

The Advent of Sales Planning Natives: Why “Set It & Forget It” No Longer Works

With the rapid advent of Anaplan’s Connected Planning, a time will likely come where we will have “Connected Planning natives”—individuals for whom dynamic, Connected Planning processes are as normal... Read Full Article

Certified Master Anaplanner Sarah Roberts—Harnessing the Power of Anaplan

Learn how Anaplan quickly fulfilled the City of Tallahassee's need for a sophisticated and adaptable software tool to use for budget planning, forecasting, and other planning processes. Read Full Article

Good Data Leads to Good Decisions

Anaplan allows you to manage data quality without having to spend months fixing source systems. Learn more about building data quality management processes into your Anaplan solutions. Read Full Article