Input required for Formula section in **Acme Vendor CC Tower Mapping, **could you please guide me for formula?

Input required for Formula section in **Acme Vendor CC Tower Mapping, **could you please guide me for formula?

Hi Ajmal,

I'm happy to help you with this. So we've told you which data sets to load and which columns you need to create. Your job is to figure out where that data is located, what the data types should be and how to get the required values into those columns.

Are you available for a webex or would you like me to explain here?

- 3 people found this helpful
Hi Ajmal,

I wasn't sure how soon you'd see my message so I went ahead and added some coaching here:

So you've loaded 2 data sets:

**Acme Vendor CC Tower Mapping**and**Acme Vendors.**It tells you you'll be putting the columns/formulas into**Acme Vendors CC Tower Mapping**and it tells you what columns you'll need to add. Your job is to figure out the data types and the formulas required to populate those columns.Check the

**Acme Vendor CC Tower Mapping**and the**Acme Vendors**data sets:- Is there any column in the current data set that would be the same as Cost Center? Perhaps you could map to it.
- When you consider data types, are there any of the 4 columns you think should be numeric rather than a label?
- Looking at Annual Target Spend, Vendor Function, and Vendor type, if there are no fields in your current data set that match that data, what about the helper data set (Acme Vendors)? Do those values/columns exist there? If so, how do we go look up data in another data set and bring it into the current data set (hint: review lookups)?

Let me know if those tips help. If not, we can jump on a webex and I can walk you through it.

Hi Ajmal,

I wasn't sure how soon you'd see my message so I went ahead and added some coaching here:

So you've loaded 2 data sets:

Acme Vendor CC Tower MappingandAcme Vendors.It tells you you'll be putting the columns/formulas intoAcme Vendors CC Tower Mappingand it tells you what columns you'll need to add. Your job is to figure out the data types and the formulas required to populate those columns.Check the

Acme Vendor CC Tower Mappingand theAcme Vendorsdata sets:Let me know if those tips help. If not, we can jump on a webex and I can walk you through it.