Sum Of Amount

Question

Hi Guys,

I have following data

Expected Output:

internal dataset 3-1.xlsx

internal dataset 3-2.xlsx

493-external.xlsx

gautiergodard · Accepted Answer

Hey @BRRLL99

Here is one way to do this.

Hope this helps!

gautiergodard · Accepted Answer

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!