Hi All
I need some help to store some figures from a report that I have. I need to store the figures in the speedometer marked with a purple circle (see attached file) = 76,9% and 90,1%. The figures are calculated as
=num(sum(aggr(count(Location.HEIGHT)*0.95/count(TransportUnitID)*sum(StockItems.AMOUNT*SKU.ITEMVOLUME/1000000000),Location.HEIGHT))/sum(aggr(1200*800*((If(Location.HEIGHT=1200, 1008,if(Location.HEIGHT=1700,1450,if(Location.HEIGHT=2200,1950,2300))))-144)/1000000000*count(Location.HEIGHT)*0.95,Location.HEIGHT)),'##,#%')
and
=num(sum(aggr(count(TransportUnitID),Location.HEIGHT))/sum(aggr(Count (Location.Location_Name),Location.HEIGHT)),'##,#%')
I need to store them with the date (today) so I in the furture can make a graph of the deveolpment in these figures like this..
Date Figure 1 Figure 2
02-11-2011 76,9% 90,1%
03-11-2011 77,2% 92,3%
04-11-2011 75,4% 91,7%
etc.
But how do I do that? think I should use something with a qvd file maybe?
Best regards
Bjarne
