Data calculation

[louise119]

Hi, 
I wanna calculate data A -data B like below.
I wanna get the data C.
Can I do that?

・data A[100,120,200,400,500]
・data B[50]
↓

・data C[50,70,150,350,450]

Thank you.

[AronC · Accepted solution]

set vValB=50;

tblA:
load * inline [
A
100
120
200
400
500
];

tblA_C:
load 
A - $(vValB) as a_C
resident tblA;

if your value B is in a tbl you could use
let vValB = peek('fieldname',-1,'tblname');

[AronC]

@louise119   If the answer helped you resolve your issue, please accept it as a Solution.