Selecting a value based on different field

[#1]

Hi Guys

My question is based on the sample table below. I would like to sum up the figures in column 'Value' (Blue) ONLY IF the text in column 'Name' reads 'Price' (Red). Please assist. I tried the following but i am not getting it right: "IF(Name like '%Price%', SUM({$}  DISTINCT Value), value=0)"

TicketNumber	ParameterId	AccNumber	TicketCenter	TicketType	TicketGroup	Name	Value
T182268	3	A147	Installations	Instal	Installation	Price	499
T182268	4	A147	Installations	Instal	Installation	Engineer	Steve
T182268	5	A147	Installations	Instal	Installation	ProductId	501
T182268	6	A147	Installations	Instal	Installation	Username	adsl
T182268	7	A147	Installations	Instal	Installation	BillingPeriod	3
T182377	112	A368	Stock Allocation	Instal	Installation	Price	2356.38
T182377	113	A368	Stock Allocation	Instal	Installation	Engineer	Installer
T182377	114	A368	Stock Allocation	Instal	Installation	ProductId	268
T182377	115	A368	Stock Allocation	Instal	Installation	Username	adsl2
T182377	116	A368	Stock Allocation	Instal	Installation	BillingPeriod	1
T227681	221	A19	Customer Support	Customer Service	Support	Engineer	Andrew
T227681	223	A19	Customer Support	Customer Service	Support	Username	home

Kind Regards

Roots

[#2]

Hi,

You can try this:

=if(Name = 'Price',sum(Value))

Regards,

Janzen

[#3]

Thank you Janzen for the response, unfortunately its still not returning anything.

Strangely if i add another variable like: =if(Name = 'Price', Value, sum(Value)) it returns results but the problem is that it is picking the wrong values (looks like its picking the first figure it encounters even though it is not a Price.

[Gysbert_Wassenaar · Accepted solution]

Try sum({<Name={'Price'}>} Value)

[#5]

Thank you Gysbert, this solution worked perfectly.

Thank you Janzen for your assistance too.