L3 sprint 2 2.3.1 QUO01 Territory Account Validation

Ssudilovsky

Hi everyone,

I am a bit confused and have been stuck for a while, how to approach the

line :" Assigned>1?: Is the account assigned to more than one territory? "

also, what is the purpose of "cf_account" line?

which modules should I reference? any ideas?

Thank you!

Accepted answers

All comments

AjayM

Hi @Ssudilovsky ,

Assigned>1? should give you TRUE if the count of territories each account is assigned to exceeds 1. For this you first have to count number of territories each account is assigned to, at account level (a SUM by A1 account). And then you would verify if this count is greater than 1, at G4 level.

cf_account will be used on UX page to apply conditional formatting ("cf") for those accounts which satisfy Assigned>1? condition. You would highlight those accounts in some color if they are assigned to more than one territory.

Hope this helps you in making progress.

Cheers!

Ssudilovsky

@AjayM Hi thanks for responding, I guess I don't understand how a child (account) can be assigned to more than 1 parent (territory). is “Candyonse” the only account that needs to be flagged?

Thank you!

AjayM

Hi @Ssudilovsky ,

Account to Territory assignment is done using numbered list and that's how you are able to assign same child to more than one parent. By the end of user story 2.5, you should be seeing only one account “Candyose” assigned to more than one territory.

Cheers!

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…