@DavidSmith Adding to your idea , I think if they need a blank cell there for values=0 , they can choose 'blank' from 'Zero values' drop down while choosing the number format for that line item.
... View more
Hi @adisulyadi , In your screenshot, column 'I' is cropped. Can you please include that column also in your screenshot for us to understand what exactly is your requirement. Thanks and regards, Aishwarya
... View more
Hi, @Johnklagholz Please check what has been selected on the page selector ( whether it is Active Employee or Employee Headcount) Also , you might not be able to manually populate data on Headcount line item since this is based on Boolean condition of whether Active Employee line item is true or false Please click 'select levels to show' and choose the desired level
... View more
Thank you so much @jesse_wilson and @LipChean_Soh ! We shall check what works best for us and communicate once successful Thanks and regards, Aishwarya
... View more
Hi All, We are trying to build a model which would contain forecasting results flowing from Python. Please direct me to the best learning material from where I can work on this integration of Python / R with Anaplan Thanks and regards, Aishwarya
... View more
Hi Visivasa, Please check if the attached screenshots are useful to you. I have used the weekday function for identifying Saturdays and changed the timescale and summary method for the cumulate line item from day to month and then created a boolean in the last line item. Thanks and regards, Aishwarya
... View more
Hi LipChean, Thanks a lot ! NaN creation using Divide function works for us. Our zeroes and either at start or at the end , hence this solves our purpose. Thanks and regards, Aishwarya
... View more
Hi @ben_speight , We have tried using NaN logic, but we are still not getting the desired result. The supporting screenshots are attached herewith. Thanks and regards, Aishwarya
... View more
Hi LipChean, I mean the chartline should be truncated at points where values are zero ( though their corresponding time periods would still remain plotted on x axis). When we filter the values, the corresponding time periods also get hidden. We would still want such time periods also to be displayed on the x axis. Thanks and regards, Aishwarya
... View more
Hi LipChean, I have tried your solution . Filtering the zero values is also resulting in hiding of the concerned timeperiods on the x axis. I would like to know if there is a solution wherein the x axis would display all the time periods irrespective of the quantities against them; only the chart plot needs to be blank for zero values. Thanks and regards, Aishwarya
... View more
Hi Team, i would like to create a chart wherein the zero values need not be plotted on a graph.In other words, I would like to create a chart excluding the null / zero values,. Please provide some guidance on the same. Existing chart screenshot is attached herewith for your ready reference. Thanks and regards, Aishwarya
... View more
Hi @kavinkumar and @rob_marshall Thanks a lot for your solutions. Meanwhile, our team arrived at a solution using NOT ISBLANK function. The screenshot of the same is attached herewith. Supplier 1 and Supplier 2 are subsets of the list called 'Supplier'. Request your inputs on the same. Thanks and regards, Aishwarya
... View more
Hi , I need help on the subject . I would like to give a conditional formula for one of my list properties based on the list subset involved. Please let me know if this possible , if yes, how ? Also if not, please suggest alternatives. Thanks in advance! -Aishwarya
... View more
It would be better if Anaplan facilitated uploading of documents in .pdf/ .jpg format , instead of using URL because not all documents are readily available on the web. Some of them might be scanned copies of confidential papers and cannot be posted on the web (to create a URL) without using a third party software/ app.
... View more
Hi, I am trying to build a training diary that should prompt an error message whenever public holidays are being selected. For example , there are 10 public holidays in a year. I need an error message to be prompted while choosing any of the 10 days. How do I use these dates in my formula conditions? For example, the dates given below are public holidays. 1/1/2019 25/12/2019 What condition / function do I need to use to trigger a message when any of these dates are selected from the model calendar?
... View more
