Forum Discussion
Custom Time Period Names
Try something like:
newcolumn =
var yearnumber = mod(year[date],100)
var decembernumber = concatenate(yearnumber,yearnumber+1)
var jantoaprnumber = concatentate(yearnumber-1,yearnumber)
var summernumber = concatenate(yearnumber,yearnumber)
return if (month([date])=12,concatenate("Winter",decembernumber),if(month([date])<4,concatenate("Winter",jantoaprnumber),concatenate("Summer",summernumber))
First bit is basically defining the YYYY values, the second bit is looking at your month and then merging summer/winter to the YYYY value as appropriate
That's probably just bad syntax on my part, it's probably missing a bracket or has an exra bracket somewhere
Thanks again. When I click on 'show error' it highlights the yearnumber variable name.
Managed to get this to work (a typo and a call to a table that didn't exist). But am getting very strange values now. So for instance 20/11/2012 comes out as Summer3333. See screenshot below:
Managed to essentially get it working using the following:
newcolumn =
var yearnumber = year[date].[year]
var decembernumber = concatenate(yearnumber,yearnumber+1)
var jantoaprnumber = concatentate(yearnumber-1,yearnumber)
var summernumber = yearnumber
return if (month([date])=12,concatenate("Winter",decembernumber),if(month([date])<4,concatenate("Winter",jantoaprnumber),concatenate("Summer",summernumber))