Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)) | |
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.