Using Weekly Instead of Daily, Monthly, or Yearly - Acumatica Generic Inquiries & Pivot Tables

RE: Using Weekly Instead of Daily, Monthly, or Yearly

Tim Rodman — Sat, 30 Mar 2019 15:25:00 +0000

Nice Hazen!

RE: Using Weekly Instead of Daily, Monthly, or Yearly

Hazen Metro — Wed, 20 Mar 2019 14:23:09 +0000

You could create a "Week Start Date" column using:

= DateAdd( , 'd',1-IIf( DayOfWeek( ) = 1 , 7, DayOfWeek( )-1 ))
Then turn your data into a pivot table. Make sure that your pivot table field for the week start date is formatted to: yyyy/MM/dd - in this way you can sort correctly by date.

This is working off our line item data, but you could replace line date with whatever date you were working with. I did steal this from our Kensium developers, just so I'm not taking all the credit ;-)

RE: Using Weekly Instead of Daily, Monthly, or Yearly

Tim Rodman — Sun, 17 Mar 2019 01:31:15 +0000

I also like the idea of Power BI for this.

The only thing I can think of within Acumatica would be to use the DateInfo table, specifically the DateInfo.WeekEnding field.

RE: Using Weekly Instead of Daily, Monthly, or Yearly

Royce Lithgo — Thu, 07 Mar 2019 21:11:01 +0000

Perhaps you need to start thinking about Power BI for all your advanced reporting needs. I did, and I've never looked back. GI can only do so much.

I am not aware of any function in GI to determine current week.

In Power BI you would solve it via a date table. I guess you could do something similar in Acumatica if you can create a new table.

Using Weekly Instead of Daily, Monthly, or Yearly

Casey Hope — Thu, 07 Mar 2019 19:57:50 +0000

I am working on a GI that shows returns for the year by day and or by month, but I was wondering if there was a way to accomplish by showing returns by each week to get a weekly percentage.

Thanks,