Sum Of Amount

[BRRLL99]

Hi Guys, 

I have following data

Expected Output:

 

[gautiergodard · Accepted solution]

Hey @BRRLL99 

Here is one way to do this. 

Hope this helps!

[BRRLL99]

Thank you for your response 

Could you please explain the regular expression part

^[^_]*-         what does it mean?

I am new to regular expression

[gautiergodard · Accepted solution]

hey @BRRLL99 

I am using this to remove the product numbers that come before each product name in the second column of your external dataset. The expression basically just removes everything before "-" symbol. 

If this provided the answer to your problem, please accept the post as a solution!