Dear all,
First of all thank you for your support. Wish you can help me.
I'm stuck at this trick. I've the next table:
| Postin Date | Invoice number | Article | Units | Unit Cost |
| 01/01/2020 | 10000 | RedCar | 50 | 3,50 € |
| 02/01/2020 | 10001 | RedCar | 10 | 3,60 € |
| 03/01/2020 | 10002 | RedCar | 5 | 3,70 € |
| 04/01/2020 | 10003 | RedCar | 3 | 3,80 € |
| 05/01/2020 | 10004 | RedCar | 1 | 3,90 € |
I need that Qlik calculate the total cost per invoice as the next table:
| Postin Date | Invoice number | Article | Units | Unit Cost | ¿This Total Cost in Qlik Sense?How to? |
| 01/01/2020 | 10000 | RedCar | 50 | 3,50 € | 175,00 € |
| 02/01/2020 | 10001 | RedCar | 10 | 3,60 € | 36,00 € |
| 03/01/2020 | 10002 | RedCar | 5 | 3,70 € | 18,50 € |
| 04/01/2020 | 10003 | RedCar | 3 | 3,80 € | 11,40 € |
| 05/01/2020 | 10004 | RedCar | 1 | 3,90 € | 3,90 € |
This total cost is: 244.80€
What I'm reaching it at the control panel the results obtained at qlik are the next ones:
| Postin Date | Invoice number | Article | Units | Unit Cost |
| 01/01/2020 | 10000 | RedCar | 50 | 3,50 € |
| 02/01/2020 | 10001 | RedCar | 10 | 3,60 € |
| 03/01/2020 | 10002 | RedCar | 5 | 3,70 € |
| 04/01/2020 | 10003 | RedCar | 3 | 3,80 € |
| 05/01/2020 | 10004 | RedCar | 1 | 3,90 € |
| | | | Average cost | 3,70 € |
| | | | Total(average cost * total units) | 255,30 € |
Total cost: 255.30€ comes from an average and not from every invoice.
Do you know how can I calculate per invoice?
Thank you for your support again.
