Skip to Content
0
May 24, 2018 at 11:44 AM

Calculated column contains wrong value (Based on other calculated column) SQL and Column Engine

431 Views Last edit May 24, 2018 at 11:49 AM 2 rev

In a Graphical Calculation View i created 2 calculated columns on the same projection-node.

One Column uses the result of the first one.
However the result is wrong.
I noticed that the 2nd column uses SQL engine and the first column uses Column Engine.

Is this a known Issue or is it an unknown bug?

Calculated column:

SQL result:

Also: Why is Column Engine the default engine for calculated Columns?
(I have trouble aggregating columns with null values and therefore switched to SQL)

If I remember right SQL Engine is also faster. So why is Column Engine the default for calculated columns?