Forum Discussion
Mat42
Resolver I
6 years agoCalculated Column - Latest Entry
I have a dataset that is a mix of quarterly data and annual data. It's similar to the simple example below: The 'Current Quarter?' column is a calculated column that I've added that identif...
amitchandak
Super User
6 years agois this your raw data, on which you are working?
Try Like
if(period = (year(today()) &"-"& year(date(year(today()) ,year(today()) -12,day(today()) ))),"Y","N")