Recent Discussions

I would like to propose a feature to instead of dividing by 1,000 to show items in thousands or 1,000,000 to show numbers in millions, that this is handled by the number formatting. This is a little used feature in excel where you can apply a format to a cell with the value $32,500 to display as $32.5. In this case the…

Hi Team, while calling through API for export for integration, if the file size is large, it is divided into chunks of 10MB each (e.g. if the file size is 890 MB, it will be divided into 89 chunks). As a result, we are getting incomplete record on the last row of every chunk and the rest of the records are being stored in…

Hi all, I am currently in the process of completing the Anaplan Way course. However, I encountered an issue with the quiz in Chapter 9: Center of Excellence. Unfortunately, I did not achieve the required score of 80% and am unable to retake the quiz to proceed to the next module. Could you please provide guidance on how I…

Whenever I create a new user account the Time zone is set to GMT, which is the Default time zone. I'd like to be able to configure the Default time zone for my environment to Mountain Time. This would result in new users being automatically configured to Mountain time.

In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data forward a year Hello, I am trying to…

This would allow to exclude nested IF-THEN-ELSE constructions.

I have just completed the GTM - Go To Market course, but couldn't see the certification in my profile in Anaplan community. Does anyone know where I can find the certificate? Also I often see people share their Anaplan badges on LinkedIn, how they got the certification image? Do you just take a screenshot and make your own…

I was wondering if it is possible to sort the modules by their cell count in the settings. At the moment there is only the possibility to export the model overview and then sort it in Excel for example. This extra step would be saved by having a built-in sorting function. For me it is important to sort the modules by their…

Hello, Good Day! Need some professional help on how I can replicate the weeknum function from Excel to Anaplan. I am relatively new to this platform. I have a module where I should be able to get the Peak Week from a date value (Peak Date). » So it's like the Weeknum function using the 'Peak Date Mid" value. I have another…

I have completed my L1 and L2 from a different organization and then moved to a new place. I have asked Anaplan team and they migrated my certificates in the new account. Before doing the Level 3, do I need to do the L1 and L2 once again in the new account? Or I can start L3 directly here.

I have completed all the training and earned the Anaplan Certified Model Builder certificate but there are no badges reflecting on my profile. Please advice.

Hello, I am stuck on this: when importing the CSV file to populate the newly created above module I got an error I'm struggling with. This is the SYS12 SKU Details Module created as requested in the training exercise: this is the CSV file to import this is the message I got after importing the file It seems that the codes…

Do Anaplan Consolidation /Fluence consultants could not be accountants? How they will understand the consolidation process if they don't have the accounting and practical expertise? Thanks !!!!

Hello team, I have uploaded 2 SS, in first as you can see in pivot that there is no line item in pivot table but it is containing data and in second screenshot in blueprint view you can clearly see line item is present. Suggest me how can see line item in pivot table

Dear Community, I joined the Community using my personal email account before my current financial analyst position. I have completed level 1 and 2 training with the account and I am now working towards obtaining the Model Builder Certification , which requires work experience certification. My question is: would it be an…

Hi, I am facing an issue in relation to getting the sales per quarter.Target Module : Account (List), Product (List), Quarter (List), Year (List) Source Module : Account (List), Product (List), Month (Time) I keep on getting zero value whenever I tried to lookup the sales from the source Module. I have already mapped the…

Hi team, I have made a copy of a model and app and am attempting to change the source model from within the app. For some reason, every page is set to the same workspace and model, but 90% of the pages are saying the model is archived so I cannot update the source model. I have checked the original app and model and it has…

Today, when we create a new line item, the number format is the only to be with summary "Sum" by default. We like to have none by default as for all other formats.

Hello, Is there a badge awarded for the completion of the "Anaplan Essentials for Customers" program? Thanks

Hi Team, When we rename the model and remapped to the same model with a new name in Model Settings-->Source Models, it is not reflecting dynamically in Import Data Sources/Imports. To see the new model name, we have to manually re-map the Import actions. It would be great if we have this feature in Anaplan- As soon as the…

Hi Team, Can we have an option to have "Formula" in the General Lists --> 'Subsets' section. It would be easy to control Subsets using formulae. Thanks Sathya

皆さん、こんにちは！ Anaplanカスタマーサクセスの藤﨑です。 Cloudworksを用いて各データストレージサービスとのデータ連携を設定する手順、特にデータストレージサービス側の設定手順をメインに取りまとめた資料を作成しました。 データ連携の検証を行う際にご活用ください。 ※あくまで疎通確認の意味合いでの検証手順です、本番運用時は社内セキュリティポリシーなどを踏まえた適切な設定を行ってください。 ■データ連携設定手順 〇Amazon S3側の設定 IAMユーザーの作成 アクセスキーの作成 バケットの作成 〇Azure Blob側の設定 ストレージアカウントの作成 コンテナーの作成 SASトークンの作成 〇Google…

Hi, I want to calculate the minimum value but exclude all zeros. I tried previously suggested solutions, but it is still not working. Any ideas?

I'm really new to Anaplan so apologies if this is a simple one. My hierarchy is set up as follows Department Hiring Role Hiring Role_Site Forecasting Task I want to be able to filter on site & department separately. However, I can't add site into the hierarchy as the same site can exist for multiple departments. I've added…

Hello friends, Can someone please help with this. I have my number in the below source module (profit) by year. I am trying to get FY24 value (profit) into below target module (i.e. 5,999) depersonalised by month: I tried yearvalue() function and it is pulling all 0's. Can somebody please advice? Thanks Kal

I have a hierarchy like this: - L1 - L2 I would like to just show the L2s in the default view, but I would also like to give my users the ability to show just the L1s if they want. But right now, it looks like the only way for users to have this ability is if I show the L1s in the default view as well. Is there a way to…