Calculated column

Stimulsoft Dashboards.WEB discussion
Post Reply
jlorue
Posts: 126
Joined: Thu Apr 15, 2021 6:33 pm

Calculated column

Post by jlorue »

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?
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: Calculated column

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
Post Reply