Total value missing from Pivot Table for some columns

[su_pyae]

Hello everyone, 

I have a pivot table similar to this one: 

Account	Segment	Month	Starting Balance	Measure 1	Measure 2	Measure 3	Measure 4	Ending Balance
101	A	1		10	2	20	15	Col (1) + Col (2) + Col (3) + Col (4) + Col (5)
		2		20	4	10	5	Col (1) + Col (2) + Col (3) + Col (4) + Col (5)
		3		3	6	5	20	Col (1) + Col (2) + Col (3) + Col (4) + Col (5)
	Total		-	33	12	35	40	-
	B
	C

For Starting Balance column, I am using IF statement. If Month is 1, Starting Balance is last year balance (using Set Analysis), Above(Col 6) which is the value from ending balance col. 

For Starting Balance and Ending Balance columns, Total value is missing. 

I don't know why it is happening or how to fix it. 

Thank you for your help in advance. 

[Jack_Guo]

Hi @su_pyae ,

What version of Qlik Sense are you using?

[marcus_sommer]

By using classical operators like + each value must be a valide numerical value - otherwise the result will be NULL. To avoid any issues with non numerical values you may use a range-function like: rangesum(Value1, Value2, ...)

- Marcus