Platform

Niranth

Hi Axel This is not easy to acheive but you can acheive this in two modules: Module 1 : The module where user has to enter values Using the lineitems from module 1 create a list (Lineitem subset) Module 2: Use line item subset, versions and a boolean formatted line item Module 1: Use this Module 2 line item to filter your versions, so only those marked version for the said line item would be visible. you have to pivot your model 1 in right way to achieve this

Niranth · ‎08-07-2019

Hi @sarah.esguerra , Have you tried using a function called "TEXTLIST", Its similar to SUM but for works for Text. Hope this helps.

Niranth · ‎08-02-2019

Hi @Ceri , Try changing the summary(In blue print view) to 'Formula'. I should solve your issue. Regards, Niranth

Niranth · ‎08-01-2019

Hi @Takamasa By Conditional Formatting I mean, You can create a separate line item which has a lesser value for Child (say 1) and a greater value for parent (say 5) and then apply conditional formatting based on the new line item which you created. You get a result where Children will have a lighter colour and parents a darker colour.(Refer my screen shot) You can even try using 3- colour scale in conditional formatting and achieve different colours for parent and child.

Niranth · ‎08-01-2019

Hi @Takamasa , Tree view is not available for Columns. However you can try using conditional formatting to differentiate Parent from Child. Hope this helps.

Niranth · ‎07-29-2019

Hi @JV271090 Currently we don't have such option.

Niranth · ‎07-29-2019

Hi @hari.prasad There is no requirement to convert the values into text, You can directly refer the 'number formatted line item' and use the condition =(equal) or <> (not equal). I'm suggesting this because converting numbers to text will all another additional layer of calculation and is not best practice.

Niranth · ‎07-29-2019

Hi @MadhabikaM , You can use the formula "<> 0" and achieve your results.

Niranth · ‎07-28-2019

Hi, Press Ctrl + Alt + Enter, you'll achieve what you were trying.

Niranth · ‎07-26-2019

Hi @usha.cherukuri , You can't add formula for text in Dashboard. Alternatively you can add formula for a line item and publish it to the dashboard using "Publish Selected Line item to Dashboard" option. Hope this helps.

Niranth · ‎07-24-2019

@VarshniR I think you should be using LOOKUP in this case and not SUM. This formula should work in module 2: Module 1.Total[LOOKUP: BU] This requires that BU list is a dimension in module 1 and a list formatted line item in module 2 Regards, Niranth

Niranth · ‎07-19-2019

Hi @AndrewClark , You can have different colours based on 'Start date', 'End date' or any other line item (in the screen shot below I have used 'values' line item for colour). You can make this selection in the "Bar Color" under labeling. If this does not work check the Chart Palettes under Dashboards -> View -> Chart Palettes. Hope this helps.

Niranth · ‎07-19-2019

Hi @ankit_cheeni , Create a subset for the list and use the same in the list formatted line item. Hope this works.

Niranth · ‎07-19-2019

Hi @Takamasa Switch is generally used in conjunction with Formula Scope, to allow a formula up until the Current Period and allow user input for the periods after current period (Switch over period here should be same as current period). It can also be used, as you observed to combine actual data with the forecast data in the version marked as 'Current' in the model

Niranth · ‎07-19-2019

Hi @kdoan, I feel the issue is with respect to the default level settings of the dashboard. What i suggest you to try is, 1. Enable personal views, under dashboard 2. Save the dashboard as "Save As My View" in the dashboard (when you can see the values). If this solves your issue, Try playing around with the 'initial page' in the dashboard settings

Niranth · ‎07-18-2019

Hi @Takamasa , I don't think I understood your question. Can you please elaborate what do you mean by 'Merit of End User?'

Niranth · ‎07-16-2019

Hi Mahesh, Try using this formula, IF ITEM(Customer) = Customer.AR Channel then Sales upload.Total - Sales upload.Total[select:PRODUCT. Fruits] ELSE IF ITEM(Customer) = Customer.FR Channel THEN Sales upload.Total[Select: PRODUCT. Fruits] ELSE 0

Niranth · ‎07-15-2019

Hi @pnataraj Please delete the list and try re-uploading it. If this doesn't work use the Sort function in the module (Sort function should be based on a line item as per the .csv file). And republish this to the dashboard.

Niranth · ‎07-15-2019

Hi @guidopolisena Its possible to control the export at the module level as suggested by Usman, but at the dashboard level it can't be restricted.

Niranth · ‎07-11-2019

Hi @MadhabikaM , You cab create a file like this With all the Parent-child relations for all levels. Update a each hierarchy a time, L1, L2 and so on. You can combine all these actions in one process. going forward you only load this one file to update all hierarchy.

Niranth · ‎07-11-2019

Hi, Publish the process to the dashboard and run the process, it will ask for the file.

Niranth · ‎07-11-2019

Hi, I feel there issue is an with the source data. When loading data into a Anaplan, it adds up data values of duplicate entries. Ex : in the source if you have City 1 = 20 City 1 = 30, When loaded it adds up shows as 50. So kindly check the import source for duplicate entries, and also make sure that all the dimension in the source has been mapped and no dimension is left un-mapped. I feel the dimension causing the issue is "uploader Employees list". because when you select a particular employee to import, it is importing all the employee's data into the particular employee selected. To test this try mapping it to the column instead of 'ask each time when the import is run' OR create a saved view with only one employee data, also make sure to hide all summary level data for this view.

Niranth · ‎07-11-2019

Hi @MadhabikaM , You can create 1 file with all the level, and create multiple actions each for one hierarchy, and you can add all these actions to the process. When you run the process after publishing to the dashboard, it will ask for only one file to load. Hope this helps.

Niranth · ‎07-11-2019

Hi, Create a similar saved view used to update count in the data hub with additional line item formatted as "No Data" First run an import from this line item to make the values Zero, and then run the final process.

Niranth · ‎07-11-2019

Hi, Since there are multiple targets, they can't be updated in a single action, However you can create multiple actions and add them to a process.

Platform

Academy

Master Anaplanner

Programs

About Niranth