关于Manjunathkn.

Manjunathkn.

Hi @chilled0ut Anaplan only works with pull/bottom up way of planning, so drilling down will work. If you want to do a top down way of planning you cannot use directly any functionality rather you need to use %Allocation to make this work as a workaround. Thanks, Manjunath

Manjunathkn.

Hi, You can create a line item in text formatted and put the formula Name(item(your list)) to bring the list into text formatted line item. And use right,left,mid,find and value function to bring into the data into date formatted. Thanks, Manjunath

Manjunathkn.

嗨，你能展示Rev02输入模块吗？谢谢，Manjunath.

Manjunathkn.

嗨@ankit_cheeni @ neg177是的，它更好地使用查找配方告诉位置计数是否格式不一致。谢谢，Manjunath.

Manjunathkn.

嗨@ neg177首先，如果您在任何行项目中拥有文本中的日期列表，那么您可以使用下面的方式将其达到日期格式。https://community.anaplan.com/t5/anaplan-platform/date-format-conversion/m -p/131438#m33698谢谢，manjunath

Manjunathkn.

Hi @Zhiying you need to put filter in your INV module. something like this. Thanks, Manjunath

Manjunathkn.

Hi Add a filter in that module from your system modules of time. Put the filter "any". Can you save the view. Thanks, Manjunath

Manjunathkn.

Hi You are getting the data only in FY. That means your line item might have values only in years but not in months. Check for the model calendar/check source module if you are wrongly getting data only in years. Thanks, Manjunath

Manjunathkn.

嗨@saisri我不认为你可以实现这一目标 - 原因很简单1.这里只有2个维度 - 产品和时间2.删除产品列表时只有12个单元格 - 在文本格式化的行项目中替代解决方案是： - 要检查第一次出现并将过滤器放在“不是空白”公式的情况下 - “如果是firstoccurance（产品，”您的列表适用于“）然后姓名（产品）else空白”注1。您应该将产品列表与文本格式化线条第2项中的维度。“产品”是您在公式谢谢中的线项，Manjunath

Manjunathkn.

嗨@RavinderB我不认为你必须通过帐户查找。您应该仅从系统模块上查找py。谢谢，Manjunath.

Manjunathkn.

嗨@RavinderB当您查找时，它也会为您提供“0”值。因此，如果要抑制您必须将过滤器> 0放置以删除零值。并与构建联系。谢谢，Manjunath.

Manjunathkn.

嗨@RavinderB你能详细说明你有什么稀疏性吗？谢谢，Manjunath.

Manjunathkn.

嗨看起来很复杂。下面是我最后一次尝试“不是blank('ATT05 CMC02 Company Code L2'.code[lookup:'Company Code'] & 'ATT12 module'.code[lookup:'Product Family'] & 'ATT09 module'.code[lookup:'Ownership'] & 'ATT16 module'.code[lookup:'Chart of Account'] & 'ATT15 module'.code[lookup:'Market'] & 'ATT02 module'.code[lookup:'Local Currency']) & Helper check" Thanks, Manjunath

Manjunathkn.

Hello, I am actually confused with the ask. I have now got the understanding let me ask you! if its correct. you want, if any of above data inputs(company code,product family,....local currency) is blank then check must throw True and local currency should also be aligned with company code, if wrong combination is entered then also check must be true? Thanks, Manjunath

Manjunathkn.

嗨@algrigore我实际上在isblank公式之外提到过。检查行项目= iSbank（旧公式）和帮助检查。谢谢，Manjunath.

Manjunathkn.

Hi Umm no i think it should be boolean only. can you show me error? Thanks, Manjunath

Manjunathkn.

嗨@algrigore，正如我在当地货币线商品上没有相关性的相关性！如何对齐这个？：1。使用布尔格式创建一个单行项，并使用名称（本地货币线项）= name（本地货币检查线项）。2.在校验线项中使用此行项目作为“Isblank（相同的公式）和（新行项目）。谢谢，Manjunath Kn

Manjunathkn.

嗨@tonyvigrand谢谢你的解决方案！但是，如果我们从系统模块查找并映射IT公司代码，那么DIM00_INPUT模块的“本地货币”行项就没有相关性，右图中？谢谢，Manjunath.

Manjunathkn.

What is the dimension you have in DIM00_input date module? Thanks

Manjunathkn.

Hi @algrigore Try this Local Currency[lookup : ATT05 CMC02 Company Code L2.Currency (CUR01)] in Local Currency check line item. Thanks, Manjunath

Manjunathkn.

@Algrigore您应该在列表属性或系统模块中作为属性之间的货币和国家列表之间的关系。然后，您必须在属性上使用查找公式作为映射。谢谢，Manjunath.

Manjunathkn.

Hi @lilasququ You are trying to change the Current Fiscal year in Deployed mode(in deployed model). if you want to change the current fiscal year, please do change in Development Model and make a sync to Deployed model. Setting Current period will help in so many things with respect to time. Let say your forecast month changes from month to month, in that case you have to move the current period. Try playing around with Currentperiodstart(), currentperiodend() and period() function. Thanks, Manjunath

Manjunathkn.

嗨@Willridge它很有趣，因为我已经尝试了。这是逻辑的解决方法！模块1模块2（使用分配列表分配）希望这有帮助！谢谢，Manjunath.

Manjunathkn.

Hi @saisri @bhatjaved Yes, DCA will help you! but along with DCA you have to use LIS(line item subset) for your case. below link will from David will help you on how to solve your problem.(refer LIS with DCA for users list) https://community.anaplan.com/t5/Best-Practices/Line-Item-Subsets-Demystified/ta-p/54309 Thanks, Manjunath

Manjunathkn.

Hi @RavinderB Please use Lookup from a system module, since it is a combined list from Accounts and products you will get correct values only in total. Thanks, Manjunath

Manjunathkn.

嗨@lokeswar如果您的数据进入到日期格式化的行项目，您可以使用@kirillkuznetsov等时期（）函数。如果您的日期是文本的，则可以在Anaplan中使用以下方法来获得各个日期的月份。谢谢，Manjunath.

Manjunathkn.

嗨，没有选项可以在页面（NUX）中冻结线条项目的anaplan。您可以使用工作表中的附加洞察力作为解决方法。谢谢，Manjunath.

Manjunathkn.

Hi @Jsdeloria21 please refer below way to get the stacked column graph in NUX(highlighted with yellow) Thanks, Manjunath

Manjunathkn.

Hi Lookup in Anaplan uses List or Date as mapping. if you want to lookup based on boolean then you need to create one more line item to bring the list and then Map. Line item 4(to be added): IF identified? THEN ITEM(your list) ELSE BLANK Loc 1 : Plant[ lookup : Line item 4] Thanks, Manjunath

Manjunathkn.

Hi, Basically your data is summing on Beginning inventory. IT says your list(SKU List) does not have top level to sit that summed values. Please add top level in your SKU list it will resolve your problem. Thanks, Manjunath