Referencing in the Blank Tariff module below the Total Handset Revenue from the P&L module, however the value is not shown, instead I see a blank.
Any ideas?
@kmht0307 What I mean is if you are validating values look at the same members (lowest level) instead of aggregated values E.g - Product A, Jan 26, Tarrif X (In source & target both) instead of ALL Products, All periods, All tarrifs, since summary could play a role and it will take more time to understand whether the formula is the issue or the data.
@kmht0307 - Why are you bringing the value in this module again? You can directly refer to the source module. As for values not being shown, is there a difference in the time granularity? Do you also not see the value when you open the subsidiary view?
The Handset Revenue is from the source module called P&L in this same model.
There is no difference in the Time and I do not see any values in the subsidiary view either.
@kmht0307- Can you add screenshot of the source module with numbers & the subsidiary view?
Source module- P&L
Subsidiary view:
@kmht0307 - You have a custom time (202601) in your target module and native (Jan 26) in source. They are 2 different dimensions. You'd need to establish a mapping between the 2 first and then lookup that to fetch the values.
Ah I see, yes thank you for sharing that
If I use the same time, I still don't see any values:
@kmht0307 - You are looking at summary values. Can you turn on the summary in your target module? While validating values, always try to compare at the same dimensions in both the modules. Preferrably, at the lowest level.
How do I do that?
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…
Estimated Level of Effort: <4 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L1 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased response time to address risks Increased forecast accuracy You Might Also Like: * Tops-Down Allocations Historical Snapshotting One of…