Hi guys,
I have a series of data which is plotted on a graph. These figures are actual volumes/projected volumes. There is also a set field which contains the last date of available data (Summary!$P$6).
I have set this up so that there is only ever one figure per day, so that there is either an actual volume, or a projected volume depending on what the last date available is.
I am using the below formula to set any values which are not required (i.e. future actual/past projections) to null (""), however the 0 value still appears on the graph, is there a different way of doing this so they don't show?
=IF(B121>Summary!$P$6,"",SUM($E$5:E121))
Regards
Ian