About ogilkons

嗨 @aishabhy05，您确定模块2中的过滤器是否相等，对于1月22日和2月22日的估算版本和预算版本是相等的？我看不到您的第一个屏幕截图，所以您能检查一下吗？谢谢，尼古拉 ... View more

Hi @var2526 , I think you should change time mapping settings for your import action according to the csv file. It's part of your exercise to set up the correct time format using the settings page. Thanks, Nikolai ... View more

Hi @akprasa1 , I am not sure I understand the purpose of Loc 1 column, so please correct me if I'm wrong. I would suggest creating a new module with Plants as a dimension and a boolean line item named Identified (please see screenshot). Let's name this module "Plant Settings" So then you can use formula for Identified column: Identified = Plant Settings. Identified [lookup: Plant] Hope that makes sense. Thanks, Nikolai ... View more

Hi @lloydramatshaba , We want the Beginning Inventory to be NOT zero for the 1st Week of a timescale. I think the problem here is either with the source line item "DAT01 Beginning Inventory. Beginning Inventory" or the reference formula is incorrect. Can you please check "DAT01 Beginning Inventory. Beginning Inventory" line item and if necessary share a screenshot of it with us? Thanks, Nikolai ... View more

@umesh嗨，您是说标准隐藏行功能吗？我不确定我在这里理解这个问题，谢谢，尼古拉 ... View more

Thanks! I agree, there is no way we can manage order in drop-down selector for Totals. And it might be a problem for huge hierarchical lists. I think the only solution I have is to use dependent drop-down: LI 1 Number LI 2 List formatted line item PARENT (drop down) LI 3 List formatted line item CHILD (drop down) LI 4 LI 1[sum: LI 3] In terms of your example, the User should firstly select Parent LI 2 and then select Child LI3. Two steps are required for selection, but it is more convenient in terms of scrolling. Hope that helps Thanks, Nikolai ... View more

Hi, Can you please describe that use case you are mentioning? @ManjunathKN wrote: Yes, i dont see a way either. but, it will be difficult to chose the child items in sum formulas. Thanks Any chances that dependent drop-down would be helpful? Thanks, Nikolai ... View more

Hi Catharina, Can you please share a formula for that line item? Thanks, Nikolai ... View more