level 3 training sprint 2 2.3.1 Assigning accounts to territory question

rinko

hello everyone

I am facing a question that after I reading user story 2.2 , which is about how to use count formula, I have to write some formula of items in QUO01 Territory Account Validation Moducle, and the Assigned>1?:  item is asked for finding if one accout is assgin for more then one terrior.

so I create a new modulce for counting it with using count formula like this screenshot

as you see, there is one account assgin more then one terrior, so I want to compare "Assgin Count" with cf_Account itme of QUO01 Territory Account Validation Moducle,

But the two moducle have different dimession, so I cannot compare (new moducle dimessions are A1_Account and G3T Territory list )

anyone can give me a hint or answer because i have spent 8 hrs for this questions, thank you so much

AjayM

Hi @rinko ,

Please check few steps to solve this:
1. 'cf_account' lineitem is meant for a different purpose. You shouldn't be using it as the source for calculating 'assign count'. Simply create a new lineitem in SYS module of G4, for the counting purpose.

2. To identify whether an account is assigned to more than one territory, you will have to arrive at the count by each account (A1). Use 2.2 lesson, and you might need SUM to arrive at this.

3. Finally using LOOKUP within the formula, you will be able to identify 'assigned >1?' result. In your snapshot, this lineitem doesn't have a formula yet, but that's how you would be generating the result for this lineitem.

Hope this helps.

Cheers!