About andis

@JaredDolich  When I checked the below report VS Anaplan's screenshot, I saw something wrong in Brazil data below.   And my stretch goal is below:   Brazil data is 1 in Anaplan's screenshot.    Did you get the same result in your level 3 checking report?   Regards, ... View more

@JaredDolich  I assigned Product Family list and Country list in the TAR01 Detailed Sales Targets module to link the TAR10 module without the SYS03 module. What do you think?.   Thanks, ... View more

@JaredDolich  I didn't see the  TAR10 The Actual Sales module in the Level 3 model start. How to download this module?   Regards,     ... View more

Hi Alex, I appreciate your information. I will try your suggestion later. Meanwhile, I've changed my configurations: 1. Added New list (numbered list type) with some properties. The content is the same as Source Module 2 above.  2. Put the SUM function in the target module.   My SUM function: Source module 1.Amounts [SUM: Product>Groups#.Group 2, SUM: Product>Groups#.Group 9]   Error message: The dimension  of mapping used for aggregation doesn't match any dimension of the source.   Questions: 1. Could you see something wrong? 2. I've created the new list above to replace Source Module 2. Which one is a good solution (PLANS)? 3. You may give other thought.   Regards,   Andi   ... View more

Hi Alex, FIRSTNONBLANK function is to skip empty cells and then take the next cell. In my case, the source module 2 always has a certain code because Group 1..Group 9 are lists. If you don't mind, I want to listen to Anaplan best practices for my business case above. Regards, ... View more

Hi Nathan, Could I get Anaplan documents that explain the data load? Thanks. ... View more