(re) - Revenue per a specific group of countries

Hi !

How does one use the TR.CoRRevenueFraction

I am trying to retrieve the % of revenue a list of companies make in a list of specific countries.

My countries are stored in List_Of_Countries.xlsx, while my ISINs in List_Of_ISIN.xlsx.

I've tried the usual way of retrieving data through the API and CodeBook, but it seems not to work.

import refinitiv.data as rd


import pandas as pd
rd.open_session()

countries = pd.read_excel("List_Of_Countries.xlsx")
isin= pd.read_excel("List_Of_ISIN.xlsx")
display(countries)
display(isin)

isin_list = isin['Unnamed: 0'].iloc[1:].tolist()
countries_list = countries.iloc[0, :].tolist()

GeoRaw = rd.get_data(
universe = isin_list,
fields = ['TR.CoRRevenueFraction'],
parameters = countries_list
)

display(GeoRaw)

Do you know how one should use the TF.CoRRevenueFraction function in CodeBook.

Thanks !

(Also, does a function for retrieve Revenue per Region exist? Something like TR.CoRRevenueFractionPerRegion) Thanks !