Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am creating a Quarter field with the following script:
'Q' & ceil(right([Acc_Calendar.Acc Period],2)/3) as Quarter
How do i then create a vCurrentQuarter and vPreviousQuarter ?
Thanks in advance
Hi Kieron,
Consider a separate numeric QuarterID field such as
ceil(right([Acc_Calendar.Acc Period],2)/3) as QuarterID
or you can try defining your quarter as a Dual:
Dual('Q' & ceil(right([Acc_Calendar.Acc Period],2)/3) , ceil(right([Acc_Calendar.Acc Period],2)/3) ) as Quarter
Cheers
Andrew
Thanks Andrew,
That gives me a numeric value for each quarter, what is the logic then to get current quarter (or previous quarter). To get Current week i have used: let vCurrent_week = num(week(today()), '00');
To get current year week i have used: let vCurrent_yearweek = weekyear(today()) & num(week(today()), '00');
But i'm confused about current quarter.
Thanks,
Kieron
Hi Keiron,
In the UI $(=max(QuarterID)) will give the current QuarterID according to the selections and $(=-1+max(QuarterID)) will give the previous.
Cheers
Andrew
You can try below one
vCurrent_Quarter= Year={"$(=GetFieldSelections(Quarter))"}
vPrevious_Quarter = Year={"$(=GetFieldSelections(Quarter)-1)"}
sum({<$(=vCurrent_Quarterr)>}Sales)
sum({<$(=vvPrevious_Quarter)>}Sales)
You can try below one
vCurrent_Quarter= Quarter={"$(=GetFieldSelections(Quarter))"}
vPrevious_Quarter = Quarter={"$(=GetFieldSelections(Quarter)-1)"}
sum({<$(=vCurrent_Quarterr)>}Sales)
sum({<$(=vvPrevious_Quarter)>}Sales)
Hi devendarlakkyreddy where should i try create those? in the script editor or in my calculation ?
Thanks,
Kieron
by using Quarter field in the front end create a variable , then use calculation in the chart