Dynamic Title

[Anonymous]

Hi

I have two fields: 'Week' which relates to calendar week number and 'WeekID' which relates to the company's financial reporting period week number. So...

'WeekID' 1 = 'Week' 19

'WeekID' 2 = 'Week' 20

'WeekID' 3 = 'Week' 21 etc to

'WeekID' 52 = 'Week' 18

When no weeks have been specifically selected the data shows the last week of the financial year (WeekID=52) which I have done, but I want the title to use the calendar week (Week=18)

Thanks

[Anonymous]

As you would have considered Week Id in Expression then use Week in title to calculate the title.

May be I have not excatly got your question.

Please post a sample if possible.

Regards

Nitin

[Gysbert_Wassenaar]

Something like ='Week ' & mod(WeekID+18,52)

[Anonymous]

The data uses max(WeekID) so when no weeks are selected then it takes data for WeekID 52 which is the last week of the financial year which is correct. But if I use max(Week) or max(WeekID) in the title it shows 'Week 52' but I want it to show 'Week 18' which is the last CALENDAR week of the financial year

[Anonymous · Accepted solution]

PFA,

Hope this helps.....

Regards

Nitin