About Panji

Panji

Hi @takushimozuru I think you need to 1. create new list(Module C) 2. Create Saved View in Module A and Module B 3. Import data module A and Module B using saved view to new list properties and in module C use formula from new list properties or 4. Import data module A and Module B using saved view to Module C Regards, Panji

Panji

Hi, Thankyou @Misbah and @Misbah to answer now i have 2 option to create like my problem

Panji

Hi Teams, I have data using List L3 but in next month(Feb 20) the structure will be change, but structure and data in previous month(Jan 20) not impact, like a picture bellow can we do that in anapan? Thank, Panji

Panji

Hi, DCA just make you can view or input data or hide data, but in summary you can view all data, If you want to see data summary based on input DCA, you need to create another line item and using formula like this in line item headcount Jan And Feb using DCA Regards, Panji

Panji · ‎04-22-2020

Hi @sandeep_bk , the reason is i want to make a journal, and the color just a note that data(color) will be import to create journal, and the sort will be order like a picture 2. Thanks, Panji

Panji · ‎04-22-2020

Hi Anaplanner, I'm import data like this, but i want to sort data based on color before im import to another after import the data will be like this can anaplan provide like that? Thanks, Panji

Panji · ‎04-22-2020

Hi, You just need checklist on INV01 setting dashboard, in SYStime not need Check sync time Thanks

Panji · ‎04-22-2020

Hi, You just need to check sync time in dashboard setting this function will be make refresh dashboard when you click planing period Regards, Panji

Panji · ‎04-20-2020

Hi @Star, I think yo miss in Confirmed Purchase Order Receipt, in course you need change OFFSET to similar function (LAG / POST / LEAD) Regards, Panji

Panji · ‎04-14-2020

Hi, Yes you can copy model prod to dev model, but you cant snyc anymore with latest model, New dev to UAT to Prod because New dev have another struktur revision tag (with UAT and Prod). Thanks, Panji

Panji · ‎04-13-2020

Hi, I think maybe in your source module you using closing balance, so it will make you Q1 amount will 0. you can change closing balance to another format. Thanks

Panji · ‎04-08-2020

Hi @Star, i think in previous activity anaplan give instruction to rename action

Panji · ‎04-07-2020

Yes you need to rename action to 5.4 and 5.5 and add to process 5

Panji · ‎04-06-2020

Hi @CommunityMember117741, You can use YEARVALUE to convert YEAR to Month in line item boolean Example as you can see line item will be true if data FY19 not blank And now you just need to read boolean if true then line item unsign will be get data form line item active Thanks

Panji · ‎04-06-2020

No, because data historical only have FY19. you dont need import to FY20

Panji · ‎04-06-2020

Hi, Yes you need to re-import Historic Volumes into Data hub DAT03 Historic Volume and after that you need check data has been the same with excel or not, if same you can import from datahub to Level 2 model. Regard, Panji

Panji · ‎04-05-2020

HI, Thankyou for file attached, i think you need check data in week 1 - week 4 have same amount like this note: in week 2 candyate im overide to 62 if not the same you can check in DAT03 Historical, if not same too maybe you need re-upload file volumes to DAT03 Historical Thanks

Panji · ‎04-05-2020

Hi, I think you should check formula in 'DEM03 Demand Forecast' maybe you miss something in a some line item, or can you give a screenshoot modul DEM03 with formula so i can identify to corrected Regard, Panji

Panji · ‎04-05-2020

Hi @Donna Marie, You just need to get data from DEM03 Demand Forecast and line item Final Forecast Regard, Panji

Panji · ‎04-02-2020

Hi, i think you need to make action process to production data, and you just need to re-upload file with the same name in source label in the production model and then you can re-run your anaplan connect, if you set default to "Admin", the file import will be the same all the time, so when you run anaplan connect and have new data, the data will note to be imported because anaplan will read same data. Thanks, Panji

Panji · ‎04-02-2020

Hi, 1. you use different list in modul 1 and modul 2, 2. you need to mapping between modul 1 and modul 2 using list in line item 3. is this case you can't use lookup with format TEXT (please cmiiw) i think i create like this Thanks, Panji

Panji · ‎04-02-2020

Hi @Sravan_Kumar , You can learn about filter in this cources https://community.anaplan.com/t5/On-Demand-Courses/Standard-Filters/ta-p/64290 or you can learn another courses in https://community.anaplan.com/t5/On-Demand-Courses/tkb-p/TrainingClasses Thanks, Panji

Panji · ‎04-02-2020

Hi @Sravan_Kumar Can you decribe specific about your problem?, i mean like you want take amount from module 1 base on month/something. But, if your problem about 'List does not have a built-in top level'. you just need to add top level(ex Total) in List Regards, Panji

Panji · ‎04-02-2020

HI@Sravan_Kumar Yes, like @VIGNESH.M say You just need create a new line item and write formula NAME(line item Month alpha) Regards,

Panji · ‎04-02-2020

Hi @Sravan_Kumar First you can create custom month and give code 1 to 12 and then in the module you can use format list(Custom Month) to line item Month in Alphabet and then you need to use formula finditem regards, Panji

Panji · ‎03-23-2020

Hi @krw6 I think you use wrong line item from module REV02, you need check again your line item name not just copy formula from activity regards, panji

Panji · ‎03-23-2020

Hi @Star you just need to publish selector to dashboard Regards, Panji

Panji · ‎03-22-2020

Hi @Sravan_Kumar like @Jared Dolich say, you can use select level to show regards, panji

Panji · ‎02-17-2020

Hi Anaplanner, I have made new module, and update module, but when i will snyc i have error like a photo How to fix it? Regard, Panji

Panji · ‎02-03-2020

Hi @MadhabikaM in Anapalan u can use POWER https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/POWER.html?_ga=2.232661148.26846517.1580695333-838474559.1577411304 Regard, Panji