Based on Quarter Selection, the Previous Quarter of selected Quarter wrt to Year must change
Hello Experts,
I have a requirement of comparing quarters based on selection. Suppose a quarter is selected then previous quarter of selected Quarter must be calculated. I tried below, But i am stuck when the year changes , the Previous doesnot reflect properly.
I have a created QuarterNew field in this format, 20211,202012,202011,20212
created a variable as
vPreviousQuarter=GetFieldSelections(QuarterNew)-1
In text box, i have used this variable,'$(vPreviousQuarter)'. When we select a value in QuarterNew col as 202011, it shows me 202010 , but when i select 20211 it shows 20210, where as i should get 202012. how can i achieve this? please assist.
