Calendar with non-standard periods. How calculate a previous period using SetAnalysis
Hello, all.
I have a some problems with my non-standard Calendar table. Our company works with own Periods.1 Period it's a 4 week. There are 13 periods in one year/ for example: 2010P01, 2010P02, .., 2010P13
I have a source table with this non-standard calendar. This table has such fields: FieldName, FieldValue YearPeriod Key, 2010P01 YearPeriod, 201001 Year, 2010 Period, 01 PeriodSequence, 1
Usually, for calculating different previous standard periods (for example, Month) I use standard approach: sum({<Month = {$(=Only(Month)-1)}>} SalesAmount)
It's work because each month has two data types (string and num - Dual data type).
In my situation I can't to use this approach. Now, for calculating current value for YearPeriod and PrevYearPeriod I use two variables: vCYP = Max(YEAR) & 'P' & Right(max(YearPeriod), 2) vPYP =FieldValue('YearPeriod Key', FieldIndex('YearPeriod Key', vCYP)-1)
it's work in my developer client, but when I implemented it on QV Server - it doesn't work (in IE Plugin Client), because my second variable vPYP not calculated. I have two questions, at least: 1) why my variable is not calculated on the server 2) How I can calculate prev periods with my non-standard calendar
