Hi,
I am having problems to create a simple calculated column obtained from 2 columns that come from different data sources.
Dashboard Table description
- Most of the fields come from a single MySQL table (Datasource 1). I am using column "A" (integer) as part of the calculation
- There is one additional column shown in the Dashboard table (Column B, also Integer) that is obtained from a relation (one of the columns of the initial MySQL table is used as parent to bring this column from a Datasource 2). The data of the column B is shown OK in the table (according to the relation).
The point is that I cannot calculate column A * Column B. I always obtain 0.
(Note: I have tried different calculations between columns of the same Datasource 1 and it works fine, but when I try to inlcude this column B that comes from Datasource 2, it does not work).
WHat should I do?
Calculated column
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Calculated column
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.