Jump to content
We've recently updated our Privacy Statement, available here. ×

Current Fiscal Quarter


Aditya Singh 3

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...