Graphing History to not drop to Zero

[srinivas_krishnamoorthy]

We are on 4.1 PL9. We have a requirement where the history value should not drop to zero in the graph. INstead it should stop at the point in the last time bucket where there is a non-zero value. Similarly Forecast in the graph should start from current bucket that will typically have non-zero value. The options in the graph do not seem to work and even horizon specific initialization to the Keyfigures does not do the trick. Any suggestions welcome to achieve this requirement.Unfortunately 4.1 does not discriminate a null and a zero.

[Former Member · Accepted solution]

Dear Srinivas,

I suugest you to use an auxiliar K-F just to graph, then implement a Macro to "interpolate" values for the K-F if zero is between two values you can assign an average instead of zero.

Best regards,

Carlos Rodríguez