Forum Discussion

heygau's avatar
heygau
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper I rankHelper 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
    Icon for Super User rankSuper User
    3 years ago

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