I need some help with two charts. On the one hand, I have a line chart that shows the accumulated amount on each end of the month date. I have created a calendar that takes me all the previous dates of each end of the month. In the graph of lines below in original currency works correctly. In the top one I added the exchange rate and I no longer get the accumulated amount.
On the other hand, I have a scatter chart. The program P5 exists twice with different amounts and dates but only appears once and I would need to show two with the different amounts and dates.
I attach a qvf with the 2 charts.
Thank you very much in advance.
It's not working because it dowsn't calculated well the exchange rate for all the programs. In fact the two charts ends with the same result which it's not correct