About CommunityMember113484

Hi, I need some help in summing on the maturity period (quarters). Module 1: no time dimension, standing data showing loan amounts in various currencies, and maturities. Module 2 is dimensioned by time (quarters) and the loan amounts are converted at the quarterly FX rates. Module 3 is dimensioned by time (quarters) and I want to create a module that shows when the loans mature. How do I go about doing this? I've tried summing on the converted loan amounts in Module 2 which does not work. Summing on the standing data allocates the loans to the correct maturity period, but the loans are of various currencies and need to be converted into EUR. Thanks, ... View more

Hi, I have a module which shows asset values on a quarterly basis. For terminated products, the current asset values are nil. However, instead of showing nil, I want to show the average asset value when in existence. In my module there is a line item for product status and this can be active, liquidating, terminated but this may change on a quarterly basis. Can someone please assist? I've been trying flags Thanks ... View more

Hi, I have a module with a list of products with different ages. I want an end user to be able to select whether from a list to show all products < 3 years, >= 3 years and >= 5 years. In my module, I have created booleans to check for each of the above. I have also created a list for the 3 periods. I'm a bit stuck now - can someone please assist? Thanks ... View more

嗨,是我t possible to export with the same formatting as the module / dashboard ? e.g. I have zeros showing as blanks or dashes, but when exported, it's coming up as 0 in the excel. Thanks in advance, ... View more

Hi, I have a module where teams are required to input weekly but at a specific schedule e.g. week ending 7th, 15th, 23rd, and last day of each month. Is it possible to configure this? Thanks ... View more

Hi, I need some help with my formula - separately they are fine, but it doesn't quite work when I combine them together. In the consol I had initially just combined the formulas in A, B & C but it did not work so I then changed the formula slightly (see below). What should the consol formula be? Thanks A IF Line item A = X THEN 'Item A % of Total' * 'Total Amount' ELSE 0 B IF Line item B = X THEN 'Item B % of Total' * 'Total Amount' ELSE 0 C IF Line item C = X THEN 'Item C % of Total' * 'Total Amount' ELSE 0 A + B + C [THIS WORKS] A' + 'B' + 'C' Consol. IF Line item A = X THEN 'Item A % of Total' * 'Total Amount' + IF Line item B = X THEN 'Item B % of Total' * 'Total Amount' + IF Line item C = X THEN 'Item C % of Total' * 'Total Amount' ELSE 0 ELSE 0 ELSE 0 ... View more

Hi, We have built a group transfer pricing model in Anaplan. Auditors are now requesting breakdowns etc, but they are unable to see the calculations as when we pull the extracts, the figures are hardcoded. What is the best way to give auditors the detail of the model? Access and request they drill down? Thanks, ... View more

Hi, I have a module that shows line items in years and uses the collect() function. I now need this in months, so have made a copy of this module, changed dimensions to months and there's currently no figures showing. How do I fix this? Thanks in advance ... View more

Hi I have a module where the formula scope is currently showing "actual version", where if time is less than switchover or isactualversion(), then it picks up actuals. I've tried to drill down, but I can't see which module actuals is coming from? Anapedia is quite vague and unhelpful. Can someone please explain? Thanks ... View more

你好,我需要一些帮助。我已经创建了一个dashboard in the NUX with 2 separate modules. I've created a Product Type Selector (Product Type A, B ...All Product Types) which then filters on the module below for the user. This works fine. Separately, I have a table that summarises the performance of each of the product types (so product type list on the left, performance across the top). How do I get this table to also link to my selector? so when a user selects Product Type A, this separate table is also filtered? I've tried repivoting the table but it just creates a selector at the top of the page, which isn't necessarily the same as the user selector? Is there a item(list) formula that will solve this? Thanks ... View more

Hi I have a module which has a section for a "reviewer" to select a boolean to mark as reviewed. Reviewers are limited to certain persons and certain products. Initially, I had just used the Employees List and created a subset for reviewers which worked fine. However, I now need only certain reviewers to certain products. What is the best way to do this? Thanks in advance, ... View more