Graph Issue

[shamitshah]

Hi,

Please see attached. There are three issues that I am trying to solve:

1) I want to stop the Curr Yr Actuals YTD line extending beyond June 2017. It is currently extending beyond the current year.

2) I want to include a cumulative to date Actuals line starting in Jan 2017 (the value in Jan 2017 being Full Year Actuals 2016 + Actuals for Jan 2017 = 1235) and  then extend out to June 2017 ( the value being 2610).

3) Need a vertical reference line separating the years.

Appreciate your assistance.

Thanks

[fvelascog72]

Hi,

Hope this helps.

Cheers

[shamitshah]

Hi Federico,

Thanks for the info. I have used parts of your solution.

I am still struggling with the Curr Yr 2017 YTD Actual line to end in 2017 Dec. It is extending out in 2018.

Any ideas?

Thanks.

[Anil_Babu_Samineni]

What was the expression you used for CY 2017 YTD??

[shamitshah]

That was used to calculate the year to date figures for the Current Financial Year i.e. 2017. This period runs from 1 Jan 2017 to 31 Dec 2017.

[fvelascog72]

Hi Shamit,

Try with this

Hope helps.