Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have field A and field B, both contain numbers ($numeric $integer in the data model). I want a field C that contains the value of A + B, so in my data load script I wrote A + B as C, but all I get are " - " values in my C field.
What am I doing wrong ?
Did one of the two fields have null value when you saw '-' for C? '+' is not able to handle 5 + Null and results in null. Try using RangeSum()....
RangeSum(A, B) as C
Did one of the two fields have null value when you saw '-' for C? '+' is not able to handle 5 + Null and results in null. Try using RangeSum()....
RangeSum(A, B) as C
Thank you sir, it does work properly now.
I indeed had " - " values in my fields, as A and B usually are mutually exclusive.
It might be easier to transform your data using CrossTable load and then using it in your chart to do this.