Cyrstal 10 with a ProvideX database.
I started trying to write a sales report that uses a fiscal calendar to group and filter records but already running in to a problem. My fiscal calendar resides in a table (GL_FiscalYearDetail) with the following fields:
FiscalYear
FiscalPeriod
PeriodEndingDate
What I need to be able to do is calculate the next period's beginning date based on the prior period's ending date. I tried grouping by Fiscal Year, then Fiscal Period and thought I could create a formula based on Previous(GroupName ({GL_FiscalYearDetail.FiscalPeriod}) but getting a "This field has no previous or next value" error.
Not sure what to try next. Any help is greatly appreciated!
I started trying to write a sales report that uses a fiscal calendar to group and filter records but already running in to a problem. My fiscal calendar resides in a table (GL_FiscalYearDetail) with the following fields:
FiscalYear
FiscalPeriod
PeriodEndingDate
What I need to be able to do is calculate the next period's beginning date based on the prior period's ending date. I tried grouping by Fiscal Year, then Fiscal Period and thought I could create a formula based on Previous(GroupName ({GL_FiscalYearDetail.FiscalPeriod}) but getting a "This field has no previous or next value" error.
Not sure what to try next. Any help is greatly appreciated!