Hi,
I am unable to view the values even after entering the formulas in the TAR01 module. The dimensions are quarterly but no value is being displayed in any format. Please refer the screenshots attached below.
Please help in this anyone.
Regards,
@muizzsk9890
check out QUARTERVALUE() formula
Make sure summary methods are set via blueprint.
Hi @KirillKuznetsov sir,
The values are still being shown as 0 everywhere. In all the formats It is being displayed as 0.
Check dimensions in source DAT02 module and find which are not matching with target module. I think it may be time (LY vs CY) and in this case you need to use LAG formula. please compare blueprints of the two.
@KirillKuznetsov
I have quarter as time dimension for DAT02 PY to CY & the Baseline Financial Forecast. Whereas the TAR01 is having Month as time dimension. I have used Baseline financial forecast Initial country sales target along with lookup for product family & country from SYS03 module.
@KirillKuznetsov Sir,
I also needed to confirm whether my selection of ICST in Baseline financial forecast was correct pick for this formula of PY Country & Product Family sales.
Hello, I am working for an implementation partner where both my current client and my company use SSO to log-in. When accessing models via the browser, my workaround to ensure that I'm not redirected to my company's SSO is by using incognito / private browsing. However, I'm unable to do this when signing into the Excel…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…