Sum N/A in a row in Qlik Senes

[LP27]

Hi Everyone,

I have scenario as below

Table 1-

Defect_Name	Defect Value
Compound	100
N/A(Process)	200
Scrap	400
N/A(Sample)	500

So now I need to only sum the Defect value starting with Defect name N/A.

example-

N/A = 700

could someone guide me.

Thanks in advance.

Regards,

LP27

[tresesco]

Try using set analysis like:

Sum({<Defect_Name={"N/A*"}>} [Defect Value])

[LP27]

Thanks! It worked well

[LP27]

Apologies!

For Few records the sum figure is right and for few records its wrong. is there any other way to group all N/A together ?