en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Jon  
#1 Posted : Friday, November 17, 2017 11:41:31 AM(UTC)
Jon
Rank: Newbie

Groups: extranet\Forum
Joined: 10/16/2017(UTC)
Posts: 3

Hi I am posting this after spending a while banging my head against an issue with dynamic dates.

I am trying to define some criteria to show aggregations for a number of previous fiscal weeks. I am using the offsets to specify year and week times but there comes a point where the offset doesn't make a difference. e.g.

Week - 1 resolves to (Week 2 2018 (WE 11/11/2017)) - which is correct for our fiscal periods
Week - 2 resolves to (Week 1 2018 (WE 04/11/2017)) - correct again
Week - 3 resolves to (Week 52 2017 (WE 28/10/2017)) - correct
Week - 4 resolves to (Week 52 2017 (WE 28/10/2017)) - shouldn't it be week 51?
Week - 5 resolves to (Week 52 2017 (WE 28/10/2017)) - still week 52

(Images attached)
UserPostedImage
UserPostedImage
UserPostedImage


It follows this pattern for every offset beyond what resolves to week 52.

Does anyone know what I've got wrong here?

Any help would be greatly appreciated.

Thanks, Jon.
Ole  
#2 Posted : Monday, December 4, 2017 8:26:14 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 448

Hi Jon,

Since you haven't got any reply to this yet, I think it is better to take it to the official TARGIT support (accessible from the TARGIT web page). Some times, these dynamic criteria related to an offset fiscal year may be quite a pain to resolve.

BR / Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok