I have got two number line items as shown below.
LineItem1 , LineItem2 , Result
1 2 1(2)
3 4 3(4)
7 10 7(10)
I want to get the result as shown above for the two line items.
Ideally i need a concatinated value.
Could you please assist me in achieving the same in Anaplan.
... View more
I have got a text field (column) say X, it has got values
x1
x2
x2
x3
wanted to creat a new line item to take the count with same value, for eg: x2 count will be 2 since it has got two entries.
... View more
IF ITEM(Status1) = Status1.Test AND 'ModuleName1'.ColumnName1=Status2.Test2 THEN 'ModuleName1'.Value[SUM: 'ModuleName1'.Type] ELSE 0
Can someone help me with the above formula, Is to ok to use an AND operation for the above calcualtion.
... View more
Hi Paul, Thank you for your prompt reply. Could you please apply your logic for data in the attached screenshot. where I have an Employee Number and I created a list item with hard coded value 1, we have got duplicate value of EMP002(occuring twice in the data). How will implement your logic over here.
... View more
Is it possible to show some kind of validations if I try to enter the same value twice.
Ideally I just want to avoid duplicate entries in to anaplan
... View more
* We have got a pop up window for inserting child entries, asking for the count of entries.
* Can I get this pop up on a cutom button click?
* Attaching the screenshot of the pop up window herewith
... View more
When we try to export the grid to excel or csv, we are getting blank rows with rest of the index numbers and with default formula.
How can we avoid these unwanted values while exporting?
... View more
If I forgot to enter a value or made it as blank in a cell in grid, how can I show a validation or something that will prevent me from saving that particular grid without that data.
Can somebody please assist me in getting a workaround for the same.
... View more
Hi,
How can I specify dimensions and measures for my bar chart or a coulmn chart.?
When i try to select a range then it is automatically picking up the x-axis and y-axis, but I want to set that differently in a chart.
Could you please help me with this query.
... View more
How can we show one of the page filter in the very first cell of a pivot table.
* Here I am attaching a file, In the attached file you can see a highlighted page filter "An_Category" which i want to display it over the first cell which is highlighted with red line.
... View more
* How can i change the color of button using RGB other than the two default colors in it.
* How can I enter a box in dashboard, where i can group the button (Mainly a boarder kind of).
Can anyone please shed some light this issues.?
Thanks in Advance
... View more
Thank you so much paul, But actualy I am facing issue with the page scrolling, I dont want page scrolling. There is some inconsistency in page scrolling, I am not able to remove that. Could you please suggest some work around for that. Thanks in advance.
... View more
Can anyone please tell me how can I resize the tables in Dashboard edit setting.
When I try to resize the table, it is not getting to a desired a size as per my requirement beyound a perticular limit.
I am trying to achieve this to avoid page level scrolling, I have already got table level scrolling so I dont want page level scrolling.
... View more