Define current year end week

143kishornaidu

Hi all,

How can i define CY end week by formula not hardcode.

we dont want to use CY week +52

so any Suggestions

rob_marshall

@143kishornaidu

Have you tried using the function END()? Create a line item for the Current Year: Period(CY Start Week) and format it as Time Period Year. For CY End Week, the formula would be END(Current Year).

143kishornaidu

GOT it