About gaurav_sharma-bng

gaurav_sharma-bng

Hi Asha, Have a look at the below screenshots which perform the same functionality. a. Create a "Qtr List" b. Create a property called "Qtr Date" in the Qtr List. This date specifies the start date for the quarter c. Create a "Time Module" boolean "Check" line item d. Use the formula to START() >= Qtr List.Quarter Date Regards, Gaurav

gaurav_sharma-bng

Hey Anya, I would like to know the methodology you have used to do the What-if Analysis. I had a similar situation in my project which I achieved via Import actions. First, I would import the input value and then snapshot the output to a output module. I would not consider my approach as the most efficient method of performing What-if Analysis as actions are slow and might also lead to funny results in some cases. Looking forward to hearing from your side on how you created the What if analysis in Anaplan. Cheers, Gaurav

gaurav_sharma-bng · ‎11-13-2019

Thanks a lot Nathan, it is a great solution

gaurav_sharma-bng · ‎11-13-2019

Thanks a lot Kavinkumar, it is a valid solution. I will implement this

gaurav_sharma-bng · ‎11-10-2019

Hi All, Hope you are having a great day so far! I have a requirement to rank projects based on specific criteria of Profits from each of them. However, they need to follow a specific order to be considered for Ranking specified below- a. Mandatory Projects should be ranked first based on their individual profits b. Government Projects should be ranked after Mandatory Projects c. Rest of the projects should be Ranked after ranking Mandatory and Government projects Ranking should happen based on Projects but it has to be done for a specific category of projects first and then move to the next category of projects

gaurav_sharma-bng · ‎09-30-2019

Hi, Thanks for your reply but Round down will not work as it will round 3.4562 to 3.0 instead of 3.4. I want a way to truncate the number till the first decimal

gaurav_sharma-bng · ‎09-30-2019

Hi All, I want to truncate the decimals from a number like below but do not want to round it. 2.22939393 -> 2.229 2.22977777 -> 2.229 2.59999 -> 2.5 instead of 2.6

gaurav_sharma-bng · ‎07-21-2019

Hi Team, I have a module in which the Timescale is Days. Now I need to get the Day from the date. E.g. for a time period 26 Jul 2015, I want to get 26 as my day. Could you please guide me on how to do that.

About gaurav_sharma-bng

Re: Time range >= check

Re: Anaplan Substitute for Excel What-If Two-Varia...

Re: Ranking Project - One Category at a time

Re: Ranking Project - One Category at a time

Ranking Project - One Category at a time

Re: Truncate decimals but not round

Truncate decimals but not round

Get value of Day(numerical) from Timescale Day

Ranking Project - One Category at a time

Ranking Project - One Category at a time

Ranking Project - One Category at a time

Re: Ranking Project - One Category at a time

Re: Ranking Project - One Category at a time

Re: Get value of Day(numerical) from Timescale Day

Re: Get value of Day(numerical) from Timescale Day

Re: Get value of Day(numerical) from Timescale Day