Level 3 Sprint 1 user story 1.7-1.10

My Approach is - calculate Redistribution Factor based on initial Account sales target,Hold and Override Value in TAR03 Country Account Calculation Module, and then use the Factor in TAR02 Account Review module

but when I am trying to Access the Factor line item for calculating Final Sales Target with respect to country in TAR02 Account Review module getting Circular reference error,

need the slightest hint to avoid circular reference error.

Comments

BenHilgendorf

Your approach is correct. Make sure that the Final Sales Targets line item is not referenced by any of the line items used to calculate Factor. The Final Sales Targets line item should not be referenced by any of the line items in TAR02 or TAR03 except for Check.

kunal_311

Hi @BenHilgendorf @swapnil_J

My approach to calculate factor:

1) Aggregate Override & Hold values in "To Change" line item and substract it from SUM of "Initial Accounts sales Target".

2) Then divide it from the ones where "initial account sales target" do not have Hold or Override Value.

Got Stuck at:

1) To calculate sum of "Initial account sales target" i need to use lookup but when i use formula - Initial accounts sales target[lookup: A1 Account] but it is showing error.

2) To calculate the denominator do i need to use IF Else statement - IF NOT Overide And Hold then sum initial sales target. But how to put it in a formula?

Any Hint/Clue is much Appreciated.

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…