Aditya Singh 3 Posted January 24, 2020 Share Posted January 24, 2020 I am trying to get the current fiscal quarter for Jan 2020(i.e Q3)when my FY starts in July-June. FiscalQuarter will give me Quarter for January month for all years as Q3, but I want to have a flag for current Quarter. Link to comment Share on other sites More sharing options...
Tyger Guzman 2 Posted January 24, 2020 Share Posted January 24, 2020 FiscalQuarter(Today()) FiscalQuarter(Date(2020,1,1)) You can use the aboveexpressions to get current Quarter. On your Document Properties ->FiscalYearOffset can be changed to have the start month of your fiscal calener match in Spotfire. Specifies the number of months from the start of the calendar year to the start of the fiscal year. For instance, a value of -1 specifies that the fiscal year starts in December of the previous calendar year, whereas a value of 2 specifies that it starts in March of the current calendar year. Link to comment Share on other sites More sharing options...
Aditya Singh 3 Posted February 1, 2020 Author Share Posted February 1, 2020 Thanks for your response but as mentioned above this function will give me only querter number, but I want a way by which I can get a flag i.e, "Current Quarter" or "Not Current". Link to comment Share on other sites More sharing options...
Tyger Guzman 2 Posted February 1, 2020 Share Posted February 1, 2020 That will get you exactly what you need! Perhaps I should have explained more : You can use more than one function in a if statement so you get a Boolean response if the years match the current year and current fiscalquarter or even use fiscalyear(). Using a year() and month() function combined you can achieve your results. Or even create a calculated column that concatenates the year and month and use that result versus the concatenation of today() or datetimenow() year and month. You can then use : If(year([date]) =year(datetimenow) and fiscalquarter([date]) =fiscalquarter (datetimenow()) , true,false) Check out this post as well https://spotfired.blogspot.com/2014/09/last-week-month-date-expressions.htmlm=1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now