Forum Discussion
Cannot pull values in from Salesforce report using Get External Data
Of course. Word Record is aligned to the left, highlighted and clickable.
If you click in the cell on empty space to the right of the word and wait a bit, at the bottom of the screen you will see another window which shows what is within record. It usually list with names and values. However, could be simply null. If click on two-arrows icon on the top right of the column, you expand all records.
Record means that Revenue has not only value inside but some other metadata as well.
SergeiBaklan Thank you for replying -- did you happen to look at the screen shot I had attached? The columns that should have $values in them simply say "Record" in each cell.
Of course. Word Record is aligned to the left, highlighted and clickable.
If you click in the cell on empty space to the right of the word and wait a bit, at the bottom of the screen you will see another window which shows what is within record. It usually list with names and values. However, could be simply null. If click on two-arrows icon on the top right of the column, you expand all records.
Record means that Revenue has not only value inside but some other metadata as well.
SergeiBaklan Thank you! That worked perfectly -- the column had both an amount and a currency associated to it!
Joanne_Thiel , you are welcome, glad to help