About DMManalili

你好,请问题。What is the best practice if I need both the columns and rows as a line item because I need to calculate the variances and the difference to maintain the clients preference on the presentation. Below is an example. thank you. ... View more

Hi, for your assistance please. How can I get every second Friday of the month? I created a line item Day identifier to get every friday but I need the second friday of the month. Thank you ... View more

嗨，请提供帮助。I would like to ask how can i lookup child which is on level 2 and the parent is on level 0? Hierarchy Target Module : Dimension : L2 cost center Source Module : Dimension : L0 Cost Center I created two line items below in my target module but when i try to get the data from the source module and lookup on the line items, its an error. Thank you! ... View more

Hi, question please. How can I calculate the payment cut-off which is happening every week. I have created a system module, screenshot below. Scenarios of the payment cut-off. 1. first cut-off - day 1 to day 7 >>> payment is after 5 working days (example: July 1 to 7, 2021 then payment day is July 14, 2021 -excluding SAT-SUN) 2. second cut-off - day 8 to day 15 >>> payment is after 5 working days 3. third cut-off - day 16 to day 22 >>> payment is after 5 working days 4. fourth cut off - day 23 to 31 >>> payment is after 5 working days (the last payment depends on the ending of the month e.g. 28th or 30th) thank you! ... View more

嗨，请提供帮助。How can I mimic the calendar in anaplan? my time period is Days but I need to get the specific weekdays equivalent (Monday to Sunday). I created a list of Monday to Sunday and just have a drop down list...how can I do it automatically in the formula? Thank you. ... View more

Hi, question please. I am doing a workflow process approval that once the preparer/inputter submitted to the approver the input cell will automatically locked. Is it possible that the input cells will not be locked to the approver side once the preparer submitted it, which means that approver can edit the numbers in the inputted cells? Thank you! ... View more

Hi, question please. I am trying to do a chart in the new ux and the time filter should be dynamic in the sense that if I choose Monthly - the chart should show monthly and if I choose in the filter the Quarterly, the chart should show quarterly figures in the chart and same with the Half year and Yearly. The time filter should show in the board so the user can choose the period to be use in the chart. Is there a way I can do that? Thank you! ... View more

嗨，请提供帮助。我想获得过去3个月的平均值，但是，平均结果应邮寄到剩余的几个月。在下面的屏幕截图中，我创建了三个行项目：佣金％ - 输入数据最新3个月（comm％） - 我使用了此公式移动（佣金％，-2，0，平均）的前3个月（comm％） -请参阅屏幕快照中的公式。我如何在4月至12月以后发布5％（平均2月，3月，3月）？谢谢 ... View more

你好,请问题。I am doing a variance analysis module which line items composed of Last Year (LY) Actual, Actual (current), Forecast, Budget and the variances line items. However, I am trying to have LAG function for the LY Actual line items. I am getting the numbers if I choose a specific month (e.g. Feb21) in the filter but when I choose FY (e.g. FY21), I am not getting the exact values. I used SUM, CLOSING Balance in the summary method or SUM but still cannot get the values. Source Module : P&L Target Module : Variance Module in the LY Actual column - I should be getting Jan 38.65 + Feb 26.90 = 65.55 What should be the correct summary method? or formula? Thank you ... View more

Hi, question please. I am doing a test variance module between line items of IC Run, Actual and Forecast using LIS, Versions and Project as my dimensions. I need to get the value of IC run, however, the module does not have time dimension in compare with my module data for the actuals and latest budget (forecast). I used the collect however, all the months are getting the values of 784M and sums all the periods that is why I am getting 6B. I just need the value of 784 as the totals for all the periods. Test variance module IC Run data - no time dimension ... View more

Hi, for your assistance please. How can I get the beginning month of the current year based on the a line item which is Month format from a line item data converted from a number format to a date format? I created a system module but I cannot use it or refer it because the data that I need to get should refer to the line item (Month). Please see ss of my modules below. Thank you. Data Module ... View more