- Community
- :
- About mohitveer_sandhu
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About mohitveer_sandhu
since
01-21-2020
12-10-2020
mohitveer_sandh
Occasional Contributor
Activity Feed for mohitveer_sandhu
- Posted Re: Add value to a given Time Duration on Anaplan Platform. 10-28-2020 01:56 AM
- Kudoed Re: Add value to a given Time Duration for rob_marshall. 10-27-2020 08:53 AM
- Posted Re: Add value to a given Time Duration on Anaplan Platform. 10-27-2020 08:26 AM
- Posted Re: Add value to a given Time Duration on Anaplan Platform. 10-27-2020 08:16 AM
- Posted Re: Add value to a given Time Duration on Anaplan Platform. 10-27-2020 07:36 AM
- Posted Add value to a given Time Duration on Anaplan Platform. 10-27-2020 05:47 AM
- Posted Re: Accessing Data in other module on Anaplan Platform. 10-19-2020 04:32 AM
- Posted Accessing Data in other module on Anaplan Platform. 10-19-2020 03:49 AM
- Kudoed Re: Restrict User Input in a Field to a certain range for Misbah. 10-09-2020 06:48 AM
- Kudoed Re: Restrict User Input in a Field to a certain range for chenjack.sonos. 10-09-2020 06:48 AM
- Kudoed Re: Restrict User Input in a Field to a certain range for sandeep_bk. 10-09-2020 06:48 AM
- Kudoed Re: Restrict User Input in a Field to a certain range for chenjack.sonos. 10-09-2020 06:48 AM
- Kudoed Re: Restrict User Input in a Field to a certain range for ChrisHeathcote. 10-09-2020 06:47 AM
- Posted Re: Restrict User Input in a Field to a certain range on Anaplan Platform. 10-08-2020 07:55 AM
- Posted Restrict User Input in a Field to a certain range on Anaplan Platform. 10-08-2020 07:46 AM
- Kudoed Re: Formatting Views in Dashboard for anirudh. 09-02-2020 11:42 AM
- Posted Formatting Views in Dashboard on Anaplan Platform. 09-02-2020 10:19 AM
- Posted Re: Using Lookup with offset or lag function on Anaplan Platform. 07-14-2020 03:16 PM
- Posted Re: Using Lookup with offset or lag function on Anaplan Platform. 07-14-2020 01:28 PM
- Posted Re: Using Lookup with offset or lag function on Anaplan Platform. 07-14-2020 12:15 PM
18
Posts
0
Kudos
0
Solutions
10-27-2020
08:26 AM
This works but if we want to extend this to such a data where for a single month there can be multiple values and we want to take only the value that’s true for the majority of the month. For example: value start date end date 101 1/1/2019 1/4/2019 102 1/5/2019 1/20/2019 103 1/21/2019 2/28/2019 Module B should have Jan-20 Feb-20 ---- value 102 103 ----
... View more
10-27-2020
07:36 AM
Can you elaborate on how can I add time(month) in module A? And also I have a restriction that module A can have only this schema.
... View more
10-27-2020
05:47 AM
Hi, I have a Module A with the following line items, format, and data: value(Format = Number) start(Format = Date (mm/dd/yyyy)) end(Format = Date (mm/dd/yyyy)) 101 1/1/2019 2/1/2019 201 3/1/2019 4/1/2020 301 5/1/2020 blank I have another module B with Time Dimension and a Line item - value_over_months that will be mapped to module A and expected data to be as given below: Jan-2019 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 value_over_months 101 101 201 201 201 201 201 201 201 201 201 201 201 201 201 201 301 301 301 301 301 301 301 301 How can I achieve this?
... View more
Labels:
10-19-2020
04:32 AM
module A has row_num as dimension and all other are line items formatted as Name = List id = text (code in name list) key, value = text
... View more
10-19-2020
03:49 AM
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
Labels:
10-08-2020
07:55 AM
Is there any way to define error instead of reassigning the value?
... View more
10-08-2020
07:46 AM
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
Labels:
09-02-2020
10:19 AM
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
Labels:
07-14-2020
03:16 PM
@einas.ibrahim Isn't there any solution without creating any extra line item.
... View more
07-14-2020
01:28 PM
I have the offset value in mod02 which gives the difference of period in Mod02 and Mod01 i.e., for Jun20 offset = 17 now I need something like Mod02.required result = offset(mod01.x[lookup:'Mapping module'.map_to], offset_value, offset_value+1) But this formula returns an error as invalid
... View more
07-14-2020
12:15 PM
@einas.ibrahim The determining factor of whether jan19 data goes to jun20 or oct20 depends on when the entity in List A joins. I have the mapping module and offset value. The Only issue is I am unable to look up and offset at the same time. For your visualization MOD01 => Page selector => Dimension B(B1) Line Item\Time Jan-19 Feb-19 Mar-19 x 100 200 300 MOD01 => Page selector => Dimension B(B2) Line Item\Time Jan-19 Feb-19 Mar-19 x 400 500 600 Mapping module => A/Line Item map_to(Format: List B) C1 B1 C2 B2 MOD02 => Page selector => Dimension A->C1 Line Item\Time Jun-20 Jul-20 Aug-20 ..... mapped_to B1 B1 B1 ..... required result 100 200 300 ..... MOD02 => Page selector => Dimension A->C2 Line Item\Time Oct-20 Nov-20 Dec-20 ..... mapped_to B2 B2 B2 ..... required result 400 500 600 .....
... View more
07-14-2020
09:31 AM
@kavinkumar Here is the error message The formula for 'MOD02'.test is invalid: 'MOD02'.test = OFFSET('MOD01'.x[LOOKUP: A], offset_value, 0) Offset value has -ve number's based on the difference between JUN20 and JAN 19
... View more
07-14-2020
09:29 AM
@einas.ibrahim Based on Dimension A means using lookup on Dimension A. Let's say the dimension values used in the MOD02 are mapped to Dimension A items say C1 is mapped to B1 and C2 is Mapped to B2 and C3 is mapped to B3. So in MOD02 I want to use the value in the current period i.e., JUN20 the value of line item MOD01.x for period JAN19 but if the dimension in MOD02 is C1 it should take the Value from MOD01.x for period JAN19 for B1 and so on. And It is not the previous year's value. It could be for any period. Jan19 ==> JUN20 or Jan19 ==> OCT20.
... View more
07-14-2020
09:08 AM
I tried but it gives invalid formula error
... View more
07-14-2020
08:21 AM
Hi, I have a module (MOD01) with time and 'A' as dimensions and a line item x. In another module (MOD02) I want to have a value of say in JUN 20 I need value of x from JAN 19 based on the Dimension 'A'(by lookup). So which function should I use or how can I use lookup with time period function.
... View more
Labels:
05-07-2020
07:37 AM
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
Labels:
Kudos given to
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 1 | |||
| 1 | |||
| 2 | |||
| 1 | |||
| 2 |