Forum Discussion
Solved
Future Quarters Display
Hi all, I'm sure this is quite straightforward but I'm really struggling to figure it out. I have a report page which is showing the current quarter and next 4 quarters worth of data and I want t...
Hi!
Do you want to be able to reference the date, or is just the text string "YYYY QQ" fine? If text only is okay you could create something like this:Quarter + 0 := VAR VarDate = today() return format(VarDate,"yyyy")&" Q"&format(VarDate,"q") Quarter + 1 := VAR VarDate = edate(TODAY(),3) return FORMAT(VarDate,"yyyy")&" Q"&FORMAT(VarDate,"q") //and so on...To get measures that update dynamically.
Hope this helps!
Hi!
Do you want to be able to reference the date, or is just the text string "YYYY QQ" fine? If text only is okay you could create something like this:
Quarter + 0 :=
VAR VarDate = today()
return
format(VarDate,"yyyy")&" Q"&format(VarDate,"q")
Quarter + 1 :=
VAR VarDate = edate(TODAY(),3)
return
FORMAT(VarDate,"yyyy")&" Q"&FORMAT(VarDate,"q")
//and so on...
To get measures that update dynamically.
Hope this helps!
This is perfect TomasAndersson - thank you so much!