Calculated column
Posted: Sun Apr 18, 2021 11:06 am
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?
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?