Forum Discussion

heygau's avatar
heygau
Helper I
3 years ago
Solved

Finacial week Number

I am Working on Sales Report based on Financial Year, Yes I am using Separate Calendar Table which has Finacial year    Finacial Year - July 1st to June 30th    1) First week number of finacial y...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi heygau 

    try to add a column with this:

    WeekNum2 =
    VAR _value = WEEKNUM([Date]-2,2)-27
    RETURN IF(_value>0, _value, _value+52)
     
    i tried and it worked like this:

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi heygau 

try to add a column with this:

WeekNum2 =
VAR _value = WEEKNUM([Date]-2,2)-27
RETURN IF(_value>0, _value, _value+52)
 
i tried and it worked like this:

 

  • heygau's avatar
    heygau
    Helper I
    3 years ago

    FreemanZ  Is it Possible it conteneous for next finacial Year, 

    Because 52nd week came back to first week of Year (Like Cycling)

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      you want the 1 in circle to be 53? like 52, 53, 54...?