Alternate State in if condition

[mahendragaur]

Hello All,

I have a list box contains current quarter which has alternate state (say State_1) and having values in below format

• 2015 Q1
• 2015 Q2
• 2015 Q3
• 2015 Q4
• 2016 Q1
• 2016 Q2
• 2016 Q3
• 2016 Q4

and below is the expression (calculate previous quarter) which I have used in a variable.

So, I want to know how it will work for State_1 in my variable. 

Calculate Previous Quarter

=if(right(GetFieldSelections([Year + Quarter]),1)=1,(left(GetFieldSelections([Year + Quarter]),4)-1) &' Q4',
(left(GetFieldSelections([Year + Quarter]),4)) & ' Q' & (right(GetFieldSelections([Year + Quarter]),1)-1))

Regards,

Mahendra

[Gysbert_Wassenaar · Accepted solution]

Use the Only function instead of the GetFieldSelections function:

=if(right(Only({State_1} [Year + Quarter]),1)=1,(left(Only({State_1} ([Year + Quarter]),4)-1) &' Q4',
(left(Only({State_1} ([Year + Quarter]),4)) & ' Q' & (right(Only({State_1} ([Year + Quarter]),1)-1))