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:

     

heygau's avatar
heygau
Helper I
3 years ago

FreemanZ 

In Our Business Every Wednesday we conduct Sale Week  That Starts First Wednesday of  Each Financial Year, Then Again Next Year also First wednesday of Next Financial Year Satrts Sale week 1.


So, Once this Financial Year Ends, From Next July First Wednesday it Should reset to Sale week 1 

FreemanZ's avatar
FreemanZ
Super User
3 years ago

"July First Wednesday it Should reset to Sale week 1 ", i thought the solution covers that, or is there still something misconsidered?

  • heygau's avatar
    heygau
    Helper I
    3 years ago

    Beautiful, Its works Mate Thanks Well Done