bi-weekly usage formula?

[Kperkins]

I am a self-taught Crystal user - and this help forum is awesome! I need help with a formula to determine bi-weekly usage, based on the current date.

Currently, this is the formula I am using to determine usage by month, but I need help - any suggestions would be great!

{iminvloc.usage_ytd}/((currentdate-date(2002,01,01))/7))*4.33

Thank you in advance!

 

[Kperkins]

I also wanted to know if this is the best way to determine monthly usage based on current date?

Thank you.

 

[Naith]

Your formula is deriving 4(and one third) weekly information, as opposed to monthly. Having said that, I would have expected "currentdate-date(2002,01,01)/7" to fall over because it's mixing up dates and integers. You might want to consider using the 'month' function.

Are you able to group your usage by your date field in a monthly and/or bi-monthly group. (Group on the date field and change 'This section will be printed' option to month and/or two weeks.)

Naith

 

[synapsevampire]

Group by the date, then you can select how Crystal groups that date, including for each half month or every two weeks.

Right click the date group and select change group, change the this group will be printed for area.

Now use whatever summing, etc., you'd like based on the group.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com