Skip to Content

How do l resolve this Formula - Kindly assist

I have my prompt set as Fiscal year which does not line up with calendar yr. Only Jan, Feb and Mar of each year lines up with actual calendar date. All other period April to Dec is ahead by 365 day. How can l make user response see April, May, June, July, August, Sept, Oct, Nov, Dec 2018 as current date April to Dec 2017 when selected from prompt or maybe for April to Dec less 365 days since thosee are the month/yr ahead. See formula below

If (formatdate(todate(UserResponse(“Prompt Text”);"Mmm yyyy");"Mmm yyyy")=FormatDate(CurrentDate();”Mmm yyyy”)) Then ([AMT]/DayNumberOfMonth(LastDayOfMonth(CurrentDate())))*DayNumberOfMonth(CurrentDate()) Else [AMT]

Fiscal Year. Calendar Yr

Jan 2017. Jan 2017

Feb 2017. Feb 2017

Mar 2017. Mar 2017

Apr 2018. Apr 2017

May 2018. May 2017


Dec 2018. Dec 2017

Pls Note: when I use curent date with Userresponse in the formula its not peforming other conditions of the formula because April,May....Dec 2018 FY is off with Calendar and userresponse prompt is based on FY and formula is calling clendar year. Help me pleaseeee - really appreciate this greatly!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers