Slowly Changing Dimensions QV

[emteam162]

Hi all,

I need your help, i explain

i want to keep the history of my table

ID	field1	field2	field3	field4	Product	date	Price	Step	scd_active	scd_end	scd_start	scd_version
330924	5	4	2	2	a	23/09/2013	150	a	0	23/09/2013	23/09/2013	1
478422	5	4	2	2	b	23/09/2013	150	b	0	23/09/2013	23/09/2013	2
478423	5	4	2	2	c	23/09/2013	150	c	0	23/09/2013	08/08/2013	3
478424	5	4	2	2	d	23/09/2013	150	d	1	NULL	08/08/2013	4

when i use this expression sum(Price) i have 600 this result is false i will have 150 in this table field "Step" change the status

any idea please

Best regards,

Emteam