Give some idea to implement this logic in Qliksense

[kaviyarasan]

TableName:
A	B
NA	2
2	NA
3	4
NA	NA
43	21
5	3
Logic:
if(or(A="NA",B="NA"),"NA",Sum(A)-sum(B))

[mato32188]

Hi, 

if you want to create a new field (let's say "C") then in script editor:

Load

A,

B,

if(A='NA' OR B='NA', 'NA', A-B) as C

From YOUR FOLDER;

Then create simple sum(C) in your UI. 

[kaviyarasan]

Hi, I already tried it. But its return "-" instead of "NA".Give some other options . Thanks