Home

counting common data and further split with pre-determined ratio by country with a specific ID code

%3CLINGO-SUB%20id%3D%22lingo-sub-652683%22%20slang%3D%22en-US%22%3Ecounting%20common%20data%20and%20further%20split%20with%20pre-determined%20ratio%20by%20country%20with%20a%20specific%20ID%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-652683%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sample%20file%20attached%20where%20the%20column%20description%20as%20follows%20-%3C%2FP%3E%3CP%3Ecolumn-A%3A%20a%20unique%20group%20of%20data%2C%20when%20counted%20it%20gives%20value%20of%2078%3C%2FP%3E%3CP%3Ecolumn-B%3A%20Identifier%20for%20specific%20ID%20of%20group%20to%20map%20the%20reference%20table%20on%20column%20F%20to%20H.%3C%2FP%3E%3CP%3Ecolumn-C%3A%20is%20the%20results%20should%20appear%20when%20dragged%20or%20any%20automated%20way%20to%20populate%20the%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20method%20or%20rule%20user%20story%20as%20follows%20-%3C%2FP%3E%3CP%3Ecoulum-A%20cells%20should%20be%20counted%20and%20outcome%20counted%20number%20is%20referenced%20with%20Identifier%20code.%26nbsp%3B%20next%20step%20the%20identifier%20code%20has%20split%20ratio%20of%2010%25%20to%20UK%20and%2090%25%20to%20US.%26nbsp%3B%20It%20should%20split%20that%20total%20count%20value%20and%20populate%20the%20column-C%20with%20each%20split%20value%20as%20result%20with%20country%20name.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-652683%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-653229%22%20slang%3D%22en-US%22%3ERe%3A%20counting%20common%20data%20and%20further%20split%20with%20pre-determined%20ratio%20by%20country%20with%20a%20specific%20ID%20c%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-653229%22%20slang%3D%22en-US%22%3E%3CP%3EAnother%20sample%20simulation%20file%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
Shivanand2011
New Contributor

I have a sample file attached where the column description as follows -

column-A: a unique group of data, when counted it gives value of 78

column-B: Identifier for specific ID of group to map the reference table on column F to H.

column-C: is the results should appear when dragged or any automated way to populate the result.

 

the method or rule user story as follows -

coulum-A cells should be counted and outcome counted number is referenced with Identifier code.  next step the identifier code has split ratio of 10% to UK and 90% to US.  It should split that total count value and populate the column-C with each split value as result with country name.

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies