Joined: 05 Aug 2008
Online Status: Offline
Posts: 6
Topic: Creating formula for fiscal week Posted: 10 Aug 2008 at 10:01pm
Hi,
I need to group my records by fiscal week. any inputs on how i can write/create the formula for this. i am using Crystal X1, does it provide anythign there?
same for quarters also-- need to group data by different quarters, how can i generate the formula for it.
Joined: 05 Aug 2008
Online Status: Offline
Posts: 6
Posted: 15 Aug 2008 at 8:06am
The date time functions do not give the fiscal ywar weeks, it would give the calender weeks. also i do not have a date on which i can group them in the DB. I need to create it on the fly and i did not find anything for fiscal there.
I need to create the fiscal start and end week manually. any hep there?
Joined: 15 Aug 2008
Location: United Kingdom
Online Status: Offline
Posts: 48
Posted: 22 Aug 2008 at 4:03am
There are a couple of ways of tackling this.
The first is to create a fiscal week table with [Start_Datetime], [End_Datetime],[F_WeekNo] and another for fiscal quarter.(If you have not got access to the original DB you could create an Excel sheet and hook it up as a second DB). Now you can pull in the fiscal week from the database using the select:
Select col1, col2, (SELECT [F_WeekNo] FROM [F_Weeks] WHERE [RecDate] >= [Start_Datetime] and [RecDate] < [End_Datetime]) As F_Week From [MainTable]
The other is to use - as you say - a formula in crystal. Just Google it - there are plenty of solutions!
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
IP Logged
