Hi Anaplanners, On my current model, there is an export module providing a CSV template for end-users. When end-users get this CSV, I’d like them to be submitting the date format correctly (ie Q1F Y23…
Hello, New Model Builder here! I'm working to enhance an older model that uses a hierarchical list as a Custom Time Scale (CTS Months). The list is used in lieu of a time scale for most modules, howev…
Hi all- I'm trying to automatically create budget codes after a new expense has been entered via input grid on a UX page. Overall, I'm having trouble generating a numerical sequence after the other pa…
Hello, What's the formula for looking up only future periods? In our module Professional Services Forecasting, I have actuals up to and including current period and blue inputs for forecast / future p…
Hi, How can i get back the data from Line item subset back to the original line item? I used the LIS as my dropdown to another module and i want to consolidate back the data from the dropdown to my ma…
Hi I am learner till i have faced issue questions in panel Architecture of ur model and what is the meaning of stand alone model. based on that stand alone how can u use ALM by steps. Another one quer…
Hi, How can I sum my months to get the quarter value in another module? My source module is using month, i turned off of the summary SUM for Time. (to save space) My target module, i want to get the q…
I use the same formula to calculate a value in a line item, it works in one module (Sales Qty - Motor) but it doesn't work in other modules (Sales Qty - Mobil and Sales Qty - Truck). I use different s…
I am writing calculation formula which I am struggle a little, hoping anyone can help me out. When writing calculation formula in Excel, we can use ( ) to group the calculation together, but Anaplan d…
Hi guys, I am wondering if there is a way to have line items that do not apply to a specific dimension, not repeat itself within a dimension. I have a list that has another module storing details abou…
Hi, I'm trying to be able to look up a total for all the individual days of the week from my historical data. i.e, I would need to look up all the Mondays in the Month of July and sum them together. I…
Hello Community, I have one module with version as dimension. In resultant module no version dimension is used How it is possible to flow value to resultant module..... Thankyou In advance Regards, JE…
Anaplanners, Is it possible to trigger automated mails/notifications from Anaplan to users based on project stages. So if a particular Project X has moved from stage 1 to stage 2, there should be a ma…
Hi, I'm trying to look up a LI for the previous 6 months average using a TIMESUM. The formula is working but no numbers are appearing. Not sure why the numbers are not appearing. The formula is below.…
I have a UX grid, which has a couple of dimensions. Depending on what selections they make using the selectors the grid can show rows with zeros in all columns. How can I automatically hide rows with …
Hi @MarkWarren and Anaplan Experts, Is there performance impact on filtering in below scenarios (assuming its a complicated filtering logic)? Question1:The Boolean Filter line item is a subsidiary vie…
I want to know the main difference between using of anaplan connect and actions. What is different between production list and production data. Please give me the information.it will be helpful for me…
Hello, I have a csv import that is not dimensioned by time and date in the same cell. It can not be changed for a monthly process import. I am 90% of the way there. I created an import module (not dim…