Alternate State in if condition

mahendragaur — Sat, 16 Nov 2024 21:45:16 GMT

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

Re: Alternate State in if condition

Gysbert_Wassenaar — Mon, 10 Dec 2018 07:45:20 GMT

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))

topic Re: Alternate State in if condition in App Development

Alternate State in if condition

Re: Alternate State in if condition