Sum Error

[Venkatsj]

Hi ,

A  Amount	E  Amount	R  amount	Total Amount
	1		1
2			2
		5	5
6			6
	3		3
8			8
			25	Sum

While calculating in excel total amount is coming properly, But while using KPI the value is showing wrong. Please guide, should i add anymore in expression?

[abhijitnalekar]

Hi @Venkatsj ,

is the shared table represent the format of the table in the data? 

also can you please share the expression?

[Venkatsj]

Hi Abhijit, Thanks for reply. I didn't use any expression specifically. Used =Sum(Total Amount). I need KPI only for Total amount column.

[abhijitnalekar]

Hi,

Can you please share sample data?  I would like to the check at my end as this is supposed to be work. 

[Venkatsj]

Sure Abhijit.