Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have two calendars Week_UP and Week.
If the user clicks Week_UP=1 then it should show week=1 to week=12.
some what i achieved it but i am facing some difficulties kindly see the attachment.
i am using this expression in list box
=Aggr( Only({<Week = {">=$(=Max(Week_UP)) <=$(=Max(Week_Up)+11)"},Year={$(=Max(Year_UP))} >}WeekOfYear),Week,Year )
Hi,
can i use week serial for this.
Hi all,
suggest me some ideas
hI,
=Aggr( Only({<Week = {">=$(=Max(Week_UP)) <=$(=Max(Week_Up)+11)"},Year={$(=Max(Year_UP))} >}WeekOfYear),Week,Year )
in your project Max(Year_UP) will give 2015.
try to remove it or please think of it ???