Probably the title of this question is not correct, the case is that I would not know how to explain my doubt without an example.
I have a scenario where I need to add the values of products that have not yet been delivered, eg:
My Records:
+ ----------- + ------ + ------------------ + ----------- ------- +
| Products | Qty. | QtDownload | ValueUnit |
+ ----------- + ------ + ------------------ + ----------- ------- +
|. Box .. | .. 5 .. | ... | ... 2 | ..... 30,00 ....... |
+ ----------- + ------ + ------------------ + ----------- ------- +
| ... Ball ... | .. 8 .. | .......... 4 ......... | ..... 50,00 ....... |
+ ----------- + ------ + ------------------ + ----------- ------- +
I would like you to display:
+ ----------- + ------ + ------------------ + ----------- ------- + -------------------- +
| Products | Qty. | QtDownload | ValueUnit | ValorPendente
+ ----------- + ------ + ------------------ + ----------- ------- + -------------------- +
|. Box .. | .. 5 .. | ... | ... 2 | ..... 30.00 ....... | 90.00 ......... |
+ ----------- + ------ + ------------------ + ----------- ------- + -------------------- +
| ... Ball ... | .. 8 .. | .......... 4 ......... | ..... 50.00 ....... | 200.00 ....... |
+ ----------- + ------ + ------------------ + ----------- ------- + -------------------- +
Basically, I need to add COLUNM
to each ROW
by doing a certain calculation to display the result:
- COLUMN
"End Value" showing Remaining Value of Product to which they have not been delivered:
Qtd - QtD Distain * ValueUnit = End Value
And how to sum all these values after the display?
I do not think SUM(ValorPendente)
will work for this case.