Define current year end week

143kishornaidu
edited June 7 in Modeling

Hi all,

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

we dont want to use CY week +52

so any Suggestions

Best Answers

  • rob_marshall
    Answer ✓

    @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
    Answer ✓

    GOT it