Skip to main content
N
Nitishkrish16
August 25, 2023

Values are correct in Data Explorer and throwing error in report and excel.

  • August 25, 2023
  • 1 reply
  • 0 views

Dear community, 
I'm using a getdatacell formula to sum few range of rows. The formula is correct and I'm getting the correct/desired output in the data explorer. But, when I try rendering it in the report and excel. It throws an error with "#ERROR'rowname'". I'm not sure what causing this issue. Is it because of the column override I'm using or some settings are driving the issue. It throws error Any solution to this would be appreciated. 

Nitishkrish16_0-1692975627889.pngNitishkrish16_1-1692975664524.png

Please find the attached 2 images of data explorer and report output. The values in the data explorer are displaying. And the in the report it's throwing #ERROR: Rowname. 

1 reply

J
JackLacava
August 26, 2023

Hey, it's hard to say anything without seeing the actual row definitions, so you might want to post those. Also specify the Onestream version please (it appears at the top of the login screen).

A wild guess is that there might be some complex Parameter involved that is not resolved correctly in Excel and Reports.

Terms & ConditionsAccessibility statement