how to write if condition on the script without loading the data using Inline fucntion

[Sarath123]

Hello,

I have the data as  attached below.
I need to calculate the total and company sales based on the code by writing on the script. I cannot use Inline function because I have huge data.
For code (1530) the sales should be sum of sales for code (1530)-code (1547)-code (15500140)-code (15500240)-code (15904001)-Code(15904002)-code (15904003)
Both Company and Total should be calculated like the above expression
Can someone help me to find a solution 

[StarinieriG · Accepted solution]

Hi,

try with the file attached

[Sarath123]

Many Thanks 😊

[Sarath123]

For the below data where both codes were mentioned

[StarinieriG]

Try to see the new file attached.

Now you have multiple fields for each code