Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a floor databae dates and the sales. I would like to make comparisons year Vs previous year. I did some variables:
VMaxDate =(max(DATEFINANCIAL)) this returns 41333 because Datefinancial is a floor.
VPriorDate = vMaxYear -1 this returns 41332
I would like to do calculations with this variables, but with this results I couldn't do, did you know how to solve this problem?
Thank's
Eduard
Hi,
Please make the corrections, the expression is as below-
For Current Year :
Sum({<year= {$(=max(Year))}>}Sales)
For Previous Year :
Sum({<Year= {$(= max(Year-1))}>}Sales)
use date function:
Date(VMaxDate) and for previous year : =addmonths(date(VMaxDate),-12)
Hi,
Please see below example-
For Previous Month:
Sum({<Month= {"$(=MonthName(addmonths(max(date),-1))"}>}Sales)
For Current Month:
Sum({<Month= {"$(=Monthname(max(date)))"}>}Sales)
Hi,
Please make the corrections, the expression is as below-
For Current Year :
Sum({<year= {$(=max(Year))}>}Sales)
For Previous Year :
Sum({<Year= {$(= max(Year-1))}>}Sales)
Hi
For Current Year :
sum({<PERIOD_YEAR={"$(=max(PERIOD_YEAR)"}>}[Net Amount])
For Previous Year :
sum({<PERIOD_YEAR={"$(=max(PERIOD_YEAR)-1)"}>}[Net Amount])
it works
Hi Neha,
The problem is when I want to apply the same logic to calculate the previous month!!
and doesnt work
Sum({<CalendarMonthName= {$(= max(CalendarMonthName-1))}>}IMPORTBRUT)
Hi
use the below exp for the monthname condition
=Month( AddMonths(START_DATE,-1))
Hi ecabanas,
Means you want to calculate for current YearMonth and Previous YearMonth?
Like for Dec2012 and Dec2011..
yes, that's I want to do!!!!
HI,
Try this for the last Year Month
Sum ({<Date = P({<Year={$(=max(Year)-1)}>}Date)>}Sales)
Regards,
Nirav Bhimani