Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I would like to make calculations on a table.
Sourcedata:
I tried to make a calculated field in my load script:
(Column2+Column3) as 'CalculatedColumn'
But the output of "CalculatedColumn" is empty in my charts where Column 1 is 2.
I expected 150.000 + 0 is 150.000 and 300.000+0=300.000.
Could anyone tell me why this column is empty?
Thanks in advance.
Pascal,
Try this out:
In a simple table:
Dimensions: column 1, column 2 and column 3
Expression: RangeSum([column 2],[column 3])
Or
Expression: Sum([column 2]) + Sum(If(Not IsNull([column 3]),[column 3],0))
Cheers
Pascal,
Try this out:
In a simple table:
Dimensions: column 1, column 2 and column 3
Expression: RangeSum([column 2],[column 3])
Or
Expression: Sum([column 2]) + Sum(If(Not IsNull([column 3]),[column 3],0))
Cheers
Rangesum was solution, thank you!
By the way, I did it in load script
Pretty good Pascal. Happy to help you