Define current year end week

Options
143kishornaidu
143kishornaidu
edited June 2023 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

Capture.PNG

Best Answers

  • rob_marshall
    rob_marshall
    Answer ✓
    Options

    @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
    143kishornaidu
    Answer ✓
    Options

    GOT it

Categories