how can I write if statement on the script for the below data

[Sarath123]

Hello,
I have the data as shown below
code     Total sales    company sales   
1101         140000             10000
11010       200000             50000
11020      1000000            90000 

My requirement was to compute company sales per code.
Suppose for code(1101) the cmpny sales are 10000
But I have another condition
for the code(11010) the sales should calculated as   companysales[code(11010)] -  companysales[code(11020)]

I cannot find a way to define that on the script?
Any suggestions!

[StarinieriG · Accepted solution]

Hi,

something like this? File attached

[Sarath123]

Thank you 😊
It worked