Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sum({$<
[Bill Date] = {"<=$(_SysCalendarLastWorkingDayCurrYear)>=$(_SysCalendarYearStartCurrYear)"},
Year = {*},
Period = {*},
Date = {*},
Month = {*},
[Calendar Year] = {*},
QuarterName = {*},
[Item Group Code] = {500, 501, 510, 530, 100},
[LinkId] = {"FIN"}
>}
[Bill Value] * $(RevenueRate))
I know this has been answered, but I can't find a posting simple enough for my level of expertise.
The code above deliveries each of the last 11 months from November 2015 to January 2015 by month.
I want to show the previous 12 months. Ex: November 2014 to October 2015 for a chart printed today (November 19, 2015). Next month the data will show December 2014 to November 2015.
I apologize for asking a question that has been answered before, but I could not get those answers to work. Thank you for all your help.
I hate to admit this Sunny but I spent several hours reading postings on this site and trying alternative answers. I try to solve the problem myself before posting. But at this point I am completely lost.
Perhaps the best response is to describe what I am trying to do and ask for help with the correct variables and expression:
For the prior twelve months I want to show the total sales by month. This is not a rolling total but each month is individually reported. This table reports only the months in the current year.
Period | 2015 |
1 | 1,128,292.3 |
2 | 978,284.0 |
3 | 998,071.2 |
4 | 1,548,605.0 |
5 | 1,092,847.5 |
6 | 978,938.3 |
7 | 1,047,483.8 |
8 | 970,740.8 |
9 | 636,116.6 |
10 | 558,025.4 |
11 | 497,362.4 |
How do I get the months of Dec-14, Nov-14, Oct-14, etc? (now the boss wants 18 month history). How do I set it up so next month old history drops off and the latest month is picked up? The date field I need to filter on is [Bill Date]. The [Bill Date] filed looks like '01/05/2015'.
Thank you.
What is the expression you are using for this variable -> $(_SysCalendarYearStartCurrYear)
I hate to admit this Sunny but I spent several hours reading postings on this site and trying alternative answers. I try to solve the problem myself before posting. But at this point I am completely lost.
Perhaps the best response is to describe what I am trying to do and ask for help with the correct variables and expression:
For the prior twelve months I want to show the total sales by month. This is not a rolling total but each month is individually reported. This table reports only the months in the current year.
Period | 2015 |
1 | 1,128,292.3 |
2 | 978,284.0 |
3 | 998,071.2 |
4 | 1,548,605.0 |
5 | 1,092,847.5 |
6 | 978,938.3 |
7 | 1,047,483.8 |
8 | 970,740.8 |
9 | 636,116.6 |
10 | 558,025.4 |
11 | 497,362.4 |
How do I get the months of Dec-14, Nov-14, Oct-14, etc? (now the boss wants 18 month history). How do I set it up so next month old history drops off and the latest month is picked up? The date field I need to filter on is [Bill Date]. The [Bill Date] filed looks like '01/05/2015'.
Thank you.