Forum Discussion

JenaT's avatar
JenaT
Frequent Visitor
8 years ago
Solved

Split a cell into multiple rows and calculating values

I have invoice data (product names and purchased pieces aggregated on 1 row) that I need to transform into sales data, i.e. disaggregate the product name from the nr of pieces and also split the sale...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi JenaT,

     

    The question is how you make that split is the unit price always the same for the same invoice?

     

    You have several quantities but only one line for total value, what is the rule to get the split per product?

     

    Regards,

    MFelix

JenaT's avatar
JenaT
Frequent Visitor
8 years ago

 

Thanks, I did not know about the line feed.

But I am still presented with the problem of splitting sales amounts between the products. Is there any possible solution to that using the advanced editor for example or any other way?

MFelix's avatar
MFelix
Super User
8 years ago

Hi JenaT,

 

The question is how you make that split is the unit price always the same for the same invoice?

 

You have several quantities but only one line for total value, what is the rule to get the split per product?

 

Regards,

MFelix