About mohitveer_sandhu

Hi I have a config module(Config Module1) that contains key-value pairs with start and end dates. For example customer_id (format = text) customer_name (format = list formula = finditem(list1, customer_id)) key value start end 1 cust1 category c1 March 01, 2022 March 05, 2022 1 cust1 category c2 March 06, 2022   2 cust2 category c1 March 01, 2022   1 cust1 key2 value2 date2   1 cust1 key3 value3 date3     And I have a module (Module1) with the following schema and sample data: date (format = date) customer_id (format = text formula = finditem(list1, customer_id)) metric1 (format = number) March 01, 2022 1 101 March 01, 2022 2 102 March 02, 2022 1 103 March 02, 2022 2 104 . . . . . . . . . March 05, 2022 1 106 March 05, 2022 2 107 March 06, 2022 1 108 March 06, 2022 2 109   Now I want to add a category column in Module1 and the value of this category column should be based on the value corresponding to key = 'category' and based on customer_id and the date in Module 1 should be between the start and end date of Config Module1. And the result should look like this: date customer_id category metric1 March 01, 2022 1 c1 101 March 01, 2022 2 c1 102 March 02, 2022 1 c1 103 March 02, 2022 2 c1 104 . . . . . .   . . . March 05, 2022 1  c1 106 March 05, 2022 2 c1 107 March 06, 2022 1  c2 108 March 06, 2022 2 c1 109   How can I implement this in Anaplan?         ... View more

Hi,   I have 2 modules say A and B Module A has id, name, key, value, key2_value For example: id     name         key           value            key2_value 1         x              k1              v1 row_num id name key value key2_value 1 1 x k1 v11   2 1 x k2 v12 v12 3 1 x k3 v13   4 2 y k1 v21   5 2 y k2 v22 v22 6 2 y k3 v23   The formula for key2_value is IF key = "k2" THEN value ELSE BLANK   Module B has name as rows and line item as key2_value name key2_value(requiredValue) x v12 y v22   I want the key2_value(requiredValue) in the line-item that will be mapped to module A. How can I achieve this as using simple lookup returns only blank? ... View more

Hi   I want to get user input in a certain line item related to number format but want to restrict the user input between 0 and 100. If the value input is between 0 to 100 then this value must be used as it is. But if the user input is <0 or >100 then it should return an error or must convert the value directly to the limit.   Summarised as follows: User input = x Case 1: if x >= 0 and x <= 100 then use x as it is. Case 2: if x < 0 or x > 100 then either return an Error or change the value to x = 0(for x < 0) and x = 100(for x > 100). ... View more

Hi, I am trying to format a view for a dashboard based on the business requirements and to make it more presentable in Anaplan. Following are my doubts, How can we change the row height in Anaplan? How can we color row to differentiate values belonging to a single row from other rows while scrolling horizontally? How can we use different number formatting for a single line item based on the value of the dimension used in page selector?For example - if I have Variance and Variance% as page selectors then for a single line item A how can we show absolute value for variance and percentage for variance%. ... View more

Hi,   We are trying to get the Min/Max and Today's date for data in the Anaplan Module. Below is the sample data present in the module.   Date Customer count Revenue Saturday, 2 May 2020 100 1000 Sunday, 3 May 2020 200 2000 Monday, 4 May 2020 300 3000 Tuesday, 5 May 2020 400 4000 We expect to get 2nd May as Minimum Date, 5th May as Maximum date and 7th May as today's date. Please Let us know how we can get these 3 extracted.   Also, could you help with how we can pull the number of elements present in a   list. ... View more