I am getting values Q1,Q2,Q3,Q4 in FQuarter field.
Now i am trying to compare value present in FQuarter and based on that I need to perform certain calculation.
- If FQuarter is equal to 'Q1' and starting month for current quarter is Jan then I need to add 1 to the existing FY else I need to deduct 1 from existing FY.
Script I have written is
If(
Match(FQuarter,'Q1') and (month(QuarterStart(today(),0) = 1)), year(Addyears(Date(FYQ1_Start),1)),year(Addyears(Date(FYQ1_Start),-1)))
But above script is executing second condition only and it is deducting 1 every time.
FYQ1_Start = 04/01/2019 and output from above script is 2018.
Can anyone please help if anything wrong I have done here.