Caluculated field - Addition of two column values in Analysis

Question & Answer
, , , , , ,
21

@ali different rows isnt the issue as it is a + and not * operation.

1 Like
22

Hi @Gaurav_Shukla - Thanks for sharing the data. Yes, the data contains NULL which causes the issue. One thing you can also do you can create the calculated field at analysis level and it should work as well. I believe QS will parse the data before doing the calculation at analysis level.

Thanks @ErikG .

Regards - Sanjeeb

1 Like
23

would coalesce(FIELD_A,0) (±/) coalesce(FIELD_B,0) (±/) be the general solution? is this documented anywhere for future users to find?