Skip to Content
0
Apr 30, 2015 at 02:51 AM

Show Year 2014, Year 2015 in my column head - HELP

24 Views

I need Formula to show previous yr as Year 2014 and Actual yr Year 2015. When I use this formula Userresponse("my prompt name"). It is NOT even showing me the current year Year 2015.

I have my fiscal year set to optional from BEX query panel in the EDIT mode. When I put the fiscal year key into the Query filter panel, YES - I see the year with the formula Userresponse("my prompt name") but then because the year is set to optional from BEX query panel its not showing. What am I missing.

I need formula to show the current year based on the year object and also another formula to show previous year based on the year object on the column header.

Thank you

Shila