Hello,

What is the correct formula that will record the actual value retrieved
weekly from an essbase cube AND will not take the line graphed to zero
for future weeks? I've tried several formula options found on this
user group and thought I had it! I've resolved for the line graphing
to zero for future weeks when data is not yet available but now, the
formula I'm using does not pick up the current week's data.

Your suggestions are most welcome! Current formula is:
=IF(WW2Q06_Actuals_Smart!F11<0,WW2Q06_Actuals_Smar t!F11,NA())

Thanks - Liz