on 11-11-2016 8:35 AM - last edited on 02-03-2024 6:58 PM by postmig_api_4
Hi,
I've to display the sales by month using a C_Code in a vertical report without displaying the month in the report layout,
The layout is provided below Where N is last month October (Considering today is November 2016), N-1 is September & so on.
C_Code | N | N-1 | N-2 | N-3
123 |100 | 70 | 50 | 25
345 | 90 | 40 | 60 | 75
How can this be achieved ?
I tried using the formula, Sum(Count) Where (C_Month=Last_Month) but it displays for all the month in rows. I want it in the above format. Any help would be great.
Hi,
Can I assume C_Month is current month and Last_Month is Currentmonth -1?.
above formula never be true. Current Month never be equal to Last-Month (November = October).
If you are trying to get the currentmonth| CM-1|CM-2 then try formula.
CM-1:
=Month(RelativeDate(CurrentDate();-(DayNumberOfMonth(CurrentDate())+1)))
CM-2:
=Month(RelativeDate(CurrentDate();-(DayNumberOfMonth(CurrentDate())+2))) and so on....
Thanks,
Jothi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.