Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an application dealing with shares, each share having an 'in' date (bought) and an 'out' date (sold) and the value of the share.
Now I would like to display for each calendar date the global value of all shares available at this date.
Data:
share | in (dd/mm/yyyy) | out (dd/mm/yyyy) | value |
A | 01/01/2008 | 10/01/2008 | 10 |
B | 07/01/2008 | 13/01/2008 | 30 |
C | 02/01/2008 | 04/01/2008 | 20 |
D | 05/01/2008 | 15/01/2008 | 40 |
Result wanted:
01/01/2008 | 10 |
02/01/2008 | 10+20 = 30 |
05/01/2008 | 10+40 = 50 |
I can get it if I select a specific date but not for a global vision
See attached QVW
Regards,
David
Hi David,
just an idea. See the attached example for details.
Good luck!
Rainer
Hi Rainer,
I have to check if it can be done with my real data (and millions of records updated frequently), I would have prefered a dynamic solution but good idea anyway, thanks!
David