I would like to create a virtual column where I can calculate the partial amount invoiced. For example:
DAY AMOUNT PARTIAL INVOICED
1 $10 $10
2 $15 $25
3 $20 $45
Is it possible?
Thank you
Probably.
And how can do it? I have tried in different ways and the result has always been errorโฆ
Thank you Steve, I actually already created a virtual column with total invoiced but the result is the same for all the rows. I used the formula SUM(Hoja 1[IMPORTE]).
But when I have tried select only (for example) cell G3 from IMPORTE + F2 from TOTAL column it has not worked. Iโm updating the โexcelโ formula in the file of driveโฆ
Iโm afraid I have no help to offer with spreadsheet formulas.
Thank you Steve, I also think thatโs impossibleโฆ
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |