-
Re: How to calculate distinct values ?
Hi @Akshay07! Your formula is correct. If you want it not to sum to ALL PERIODS, change the Summary method of LI to "Formula" (for time). Then the calculation should be correct.1 -
Re: My model building experience in Anaplan, featuring Colin Dowda
Great article! I will share it with my aspiring Model Builders, thanks!1 -
Re: Module
Hi @Markcol! The formula is correct, but you need to double-check the time calendar and current period settings (your screenshot shows 2021, the example shows 2019):1 -
Re: Different output
If your formulas match, you need to check the data in the modules they refer to. If I remember the course correctly, there was a step to load data from CSV. You can use the Drill Down function on the…1 -
Re: 2.3.9.1 Import data into DAT03 "Expected week number in date/period"
Hi @mattb Your import worked correctly, the data is loaded. You need to "move" the loaded data one year ahead by using the formula OFFSET through the first year check. You will end up with …1

