Hi Team,
As per attached excel I Need to increase calenderweekid by 1 if calenderweekid is same for 2 fiscal weekoffset
For example
For Fiscalweekoffset 11 and 12 the calenderweeknumberid 202226,
My requirement is for fiscalweekoffset 11 the calenderweeknumberid should be 202226,
and for fiscalweekoffset 12 the calenderweeknumberid should be 202227.
just for information, Since fiscal year starts from jul1 2022 to jun 30 2023 that's why new fiscalweekoffset is added.
Regards
Prashant