Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a list box contains current quarter which has alternate state (say State_1) and having values in below format
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
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))
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))