Calculated column in DataSource from other DataSource

[jmgardn2]

I have two datasources set up. One from a SQL connection (DataSource1), and the other one as a virtual datasource from DataSource1. I have a grouping set up in the virtual datasource with a result using the Avg aggregate function. I added a calculated column to the virtual datasource to take the Avg column and multiply it by 100. However, when I view the data or attempt to use the calculated column it is blank. Any suggestions would be appreciated.

[Alex K.]

Hello,

The Calculated columns may be used only for showing in report. The "View Data" does not show the data from calculated columns.

Thank you.

[jmgardn2]

Thanks Aleksey,
The view data issue makes sense. However, if I use the calculated column in my chart, I don't get any data. Using a databand I can see the data is showing properly, however the calculated column doesn't appear to be working within a chart. Is this not supported?

[Alex K.]

Hello,

The calculated columns have limited functionality.
Please try to add the necessary column in your original query.

Thank you.