53 Week problem

[ajsjoshua]

Hi all,

I have 2 year

2015 and 2016

For 2015 i have 53 weeks,in 53 week has four days from 2015 and three from 2016

2016 has 23 weeks of data

When I use this formula

=num( Sum({<Flag_ = {1},Year_UP =  {$(=Max(Year_UP))},Week_UP = {$(=Max(Week_UP))}>}Orders )

,0.00)

Its calculating 53 week as maxweek but i want 23 week of 2016 should be selected.

Suggest me some ideas

Regards,

Joshua.

[Kushal_Chawda]

I think you need to redefine your week

Redefining the Week Numbers

[ajsjoshua]

Hi kushal,

I tried that also but still its not rectified

Regards,

Joshua.

[kaushiknsolanki]

Try this,

=num( Sum({<Flag_ = {1},Year_UP =  {$(=Max(Year_UP))},Week_UP = {$(=Max({<Year_UP =  {$(=Max(Year_UP))}>}Week_UP))}>}Orders )

,0.00)

Regards,

Kaushik Solanki

[ajsjoshua]

Hi Kaushik,

Thanks for ur reply

Not working bro same result.

[kaushiknsolanki]

Try this,

Use the quotes and check.

=num( Sum({<Flag_ = {1},Year_UP =  {'$(=Max(Year_UP))'},Week_UP = {'$(=Max({<Year_UP =  {'$(=Max(Year_UP))'}>}Week_UP))'}>}Orders )

,0.00)

If this doesnt work please share the sample data which replicates your problem.

Regards,

Kaushik Solanki