Division calculation in Qlik

[laurenr171]

Hello, I have the following table of data. I need to perform the following calculation:

(VALID_LINES – EXTRA_LINES)/VALID_LINES

How can I tell Qlik to do this? I am thinking a custom dimension but not sure where to go from there.

CATEGORY	VALID_LINES	EXTRA_LINES
A	2	0
B	3	0
C	1	0
D	1	0

[BrunPierre]

As below

Evaluate((VALID_LINES-EXTRA_LINES)/VALID_LINES) as [New Measure]

[MarcoWedel]

If the expression you posted actually is the expression you tried to use without success then you should replace the en dash with a minus sign to get it working:

hope this helps

Marco