I have a problem with Google Data Studio.
I am adding my sheet as a data source and.
There is a column in this sheet based on this formula:
= iferror (D2 * index (query (GOOGLEFINANCE (CONCATENATE ("CURRENCY:", C2, "PLN"), "price", B2-1, B2, "daily"), "select Col2"), 2.1) , "0")
Basically, this calculates the value in PLN according to the date in column B, the currency in column C and the amount in column D.
The study of Google data must obtain the result of this formula and treat it as a value.
Instead, you see no value at all that shows 0 for the entire column.
Does anyone have an idea of how to fix it or fix it?