About abhi1017

abhi1017

Hi @NishaS Assuming your data is Sales history. 1. Rank the sales history data sequentially. The formula for line item, Rank sales history would be RANK(Sales History, DESCENDING, SEQUENTIAL) 2. Cumulate the above rank sales history in another line item. Formula: RANKCUMULATE(Total Sales History, Rank Sales History, ASCENDING) 3. Use the lineitem to sort. Edit Rank and Rankcumulate formula based on you requirements. For more details on these functions: https://help.anaplan.com/en/4f94f2e7-e7d9-4bae-ba6f-2b872e8d9189 Hope this helps ~Abhi

abhi1017

Hi @CommunityMember113484 Adding/reiterating on to @Axel_H suggestion. Assuming the input module is dimensioned by Quarters/months/weeks. 1. Activate All periods from time settings 2. Refer the input line item in the line item created in new module. 3. Go to blueprint view of the new module. 4. Scroll to right in blueprint view and In the summary method select "Last non blank" for the line item in which that data is being summarised. ~Abhi

abhi1017

Hi @hyudolee Could you please elaborate or share a screenshot on where exactly you need to order a,b,c,d. ~Abhi

abhi1017

@Jerin_KJ 1. Create a boolean formatted lineitem in the grid module dimensioned by list( being used in the page selector) 2. Set version, time to not applicable. 3. Reference the page selector in this lineitem (lookup etc) 4. Use this lineitem in the filter. 4. Based on the list member selected in page selector, the module/grid will display its respective data. Pls. share some screenshots to help you in a better way. Hope this helps ~Abhi

abhi1017 · ‎11-02-2020

Hi @tejaswini You can use Breakback functionality here if the data has to also get disaggregated when input is done at a higher level. Using this function, data will be automatically disaggregated and aggregated at all levels based on the existing data. It has some limitation/shortcomings. You could explore in details about this function in the below link. https://help.anaplan.com/anapedia/Content/Modeling/Working_with_Data/Breakback.html?_ga=2.252189897.1318116279.1604340682-1450092893.1602052846 Hope this helps. ~Abhi

abhi1017 · ‎10-25-2020

Hi @kpeters The reason for this error ("Data type mismatch: format other than LIST or DATE being referenced as a relation") , the line item using which you are trying to sum is a text formatted rather date or list. In order to sum here: 1. Create another lineitem name it Cust.Mktlist and format it by Cust.Mkt list 2. Formula for Cust.Mktlist :- Finditem('Cust.Mkt',Cust.Mkt ID) 3. Now use this lineitem "Cust.Mkt list" in the sum formula. Hope this helps. ~ABhi

abhi1017 · ‎10-23-2020

@johan.marketoft I had encountered the same problem. 1. Delete the published module 2. Select the module again to publish 3. Pivot Line items to rows/Columns 4. Publish the Module. Now, If you can see line items in table , edit it and change the line items to context selector and re-publish. Hope this works, worked for me. ~ABhi

abhi1017 · ‎09-24-2020

@sosunkwo The dimension of the module isn't mapping to the formula being entered. Dimensionality of your module is a concatenated list of accounts and products i.e. A2 Accounts>Product# list rather A1 account and P2 product lists. Check the screenshot attached above in the trail for reference. ~Abhi

abhi1017 · ‎08-12-2020

@xin Could you please share screenshot of the NUX page where the module is published and where you are facing the problem. ~Abhi

abhi1017 · ‎08-12-2020

Hi @xin, I was facing the same. Seems some kinda bug. I republished the module, activated hierarchy filters and allow editing. And Is working for me now. ~Abhi

abhi1017 · ‎08-06-2020

@StephenM There is a dimensional mismatch. The formulae should cater to the dimension of the target module. It would be great if you could share a screenshot to help you further. ~Abhi

abhi1017 · ‎07-23-2020

@edeblacam I have been facing the same issue. I had raised this to Anaplan Support, thereafter our team is able to copy/paste multiple cells with a certain lag of 4-6 secs but the client is not able to do same even in chrome. ~Abhi

abhi1017 · ‎07-19-2020

@Tsuyoshi_Inoue Use Period(start()) in your month formatted line item , time range dimension-ed module. Similarly, you can check other functions like Currentperiodstart() and end() with respect to your requirement. https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/START.html ~Abhi

abhi1017 · ‎07-14-2020

@Misbah I don't know why it isn't working for me. Have raised a ticket to Anaplan. Thanks. ~Abhi

abhi1017 · ‎07-14-2020

Thanks a Ton @Misbah. I understand the logic presented. But here i need to paste values for only two months at once. (w.r.t example displayed) I cannot paste it NUX for two at once. In NUX even for one cell for the copy paste to work , i need to first double click it and then only can paste. It just doesn't happen like classic UX where in we select the cell and paste. ~Abhi

abhi1017 · ‎07-14-2020

@nathan_rudman Thanks. Already raised a ticket. ~Abhi

abhi1017 · ‎07-14-2020

@rob_marshall @DavidSmith Could you guys pls. help me with this.

abhi1017 · ‎07-14-2020

I didnt understand the requirement completely previously i guess. But this requirement can be achieved directly in NUX rather creating saved views and publishing. In the edit mode in NUX,Just need to select top level of list in setting , disable Sync page for that list and select off/label for the list ,update and publish to dashboard. I have been doing this lately. ~Abhi

abhi1017 · ‎07-14-2020

Hi @GuruAP May be you can try this.Tick the higlighted.

abhi1017 · ‎07-14-2020

@anirudh Thanks. I got a solution out of this for another requirement. 🙂 where in i need to filter the product and geo lists.

abhi1017 · ‎07-14-2020

Hi @Misbah The Copy and paste is working for only single cell at a time but the client wants to paste values for 4 cells at once from excel. Lineitem where the values are to be pasted is breakback enabled. ~Abhi

abhi1017 · ‎07-14-2020

@filip.sypniewski Its number formatted breakback enabled lineitem.

abhi1017 · ‎07-14-2020

Thanks @Misbah Will try this.

abhi1017 · ‎07-13-2020

@Misbah I have used CTRL+C and CTRL+V, but it doesn't seem to work. And the cell is not read only,As it is part of a input lineitem with allow editing activated. ~Abhi

abhi1017 · ‎07-11-2020

Hi Community, I want to copy 4-5 values from a excel sheet and paste it in a specific editable line item on the NUX dashboard. I am not able to achieve it. Is there something i am missing to achieve this/ how can this be done.? Thanks in Advance. ~Abhi

abhi1017 · ‎07-10-2020

@ifeldman As far as i remember Rev02 module is populated by import action (Volume input.CSV). The CSV file was shared as part of course. ~Abhi

abhi1017 · ‎07-09-2020

Try This. Create a saved view in the source module, lists in page selectors,line items in columns and time in rows. Then create an import action and run. Hope this works. ~Abhi

abhi1017 · ‎07-09-2020

1. Country - fine 2. P1 Product Family - fine 3. PY Country and Product Family Sales- Relook on this (Lookup and SUM functions to be used) 4. Initial Country Sales Target :- Seems fine 5. PY Account Revenue :- Relook at this formula (Lookup needs to be changed) 6. PY account/PY Country Product Family:- Seems you need to Interchange numerator and denominator 7. Inital Account Sales Target :- Its an increase that can be found from (PY Country and Product Family Sales) and (PY account/PY Country Product Family) not % Increase. Hope this helps ~Abhi

abhi1017 · ‎07-09-2020

As @Jitendra.Vishnolia mentioned try mapping Y-M. Else use custom time.YYYY-MM. As per the screenshot shared the time format in the source module is YYYY-MM.(Highlighted below.) ~Abhi

abhi1017 · ‎07-09-2020

Are you using time ranges..? could you please share the screenshot of source and target module. ~Abhi

Online Status	Offline
Date Last Visited	Wednesday