About ankulkarni

I want to create a new filed and a logic where the input will be project name which is a combination of letter and and digits. The new input field should replace '0' in the 3rd place of the project. E.g- PROJECT NAME: PR120 then new calculation field should remove '0' in the 3rd place what can be the syntax to remove or not consider 3rd digit if '0' Thanks Ankur Kulkarni ... View more

Hello all, I am looking for a solution wherein we set a specific time period ( 6 months) for certain users and post 6 months their access should be automatically terminated? is it achievable ? Thank you Ankur Kulkarni ... View more

For Shipping Time weeks, below was the logic i applied and it went through, however the data i am getting is '0' 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] to further break down i searched for other modules for shipping method dimension but no luck, the shipping method within INV01 module is not a numbered format unlike others so may be it must be an error, got stuck. Can someone please help me understand Best Regards Ankur Kulkarni ... View more

Hello, The csv file contains country name, code and parent, but needs to be imported as a flat list. A) There is no way we can leave the fields blank while importing as it is throwing errors B) Can i make changes in the source file itself to just get the countries? We do not want the parental hierarchy c) I have just mapped parent to country name ( import completed, but with errors) Is this the right way? Kindly advice, Best Regards Ankur Kulkarni ... View more

Hi, I have created a new list called 'SKU' which needs to be added at the bottom of product hierarchy for SKU's. I have denoted the hierarchy and tried importing the data. Can someone please correct what's going wrong. Thanks STEP 1 STEP 2 STEP 3 ERROR HIERARCHY Thanks ... View more

Hello, My goal is to get the 'total volume' of product being used for certain year by different cities. Below are the two data set which have been successfully mapped into Anaplan I want to pull data from DATA02 into REV02 to achieve my goal. SOURCE DATA02- (data SKU Volumes) TARGET: REV02- (data Volume Inputs) I tried using LOOKUP function but somehow unable to use it. What is the right way to map data so that my goal is achieved? Thanks ... View more

level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line items. Open the REV03 Margin Calculation module. Toggle to blueprint view to enter the following formulas for each line item: Line Item Formula Revenue 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Sales Price * (1 + Sales Price Growth %) Cost of Sales 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %) Sales Price Growth % IF 'SYS00 Time Settings'.Forecast period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Sales Price %) ELSE 0 Cost Price Growth % IF 'SYS00 Time Settings'.Forecast period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Cost Price %) ELSE 0 Current formula:- Revenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Sales Price * (1 + Sales Price Growth %) Correct Formula:- Revenue'REV02 Volume Inputs'.Volume * 'REV01 Price Book'.Sales Price * (1 + Sales Price Growth %) Current Formula:- 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %) Correct Formula:- 'REV02 Volume Inputs'.Volume * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %) ... View more

The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation. Kindly help ERROR: The formula for 'REV03 Margin Calculation'.Cost of Sales is invalid ;REV02 Volume Inputs'.Volumes is not a recognized line item or list member line item- Revenue Formula - 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Sales Price Line Item- Cost of Sales Formula- 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs ... View more