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...
Read More

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...
Read More

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...
Read More

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...
Read More

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...
Read More

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...
Read More

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....
Read More

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...
Read More

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 ...
Read More

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 ...
Read More
computer
Community Activity
29077
Members
420
Users Online
16207
Total Posts
Featured Content
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
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
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
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
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