Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following code,
IF (not match(COMPANY,'XYZ'),
SUM({1<COMPANY={'XYZ'},FinancialYear=,Date={">=$(=max(YearStart))<=$(=max(YearEnd))"}>}Values/10000000),
SUM({$<COMPANY={'XYZ'},FinancialYear=,Date={">=$(=max(YearStart))<=$(=max(YearEnd))"}>}Values/10000000)
)
For getting the last years figures what changes are to be made...??
Thanks and Regards,
Rohit
Hello everyone,
Thanx for the reply ..
I used the following codes.
CY:
SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},COMPANY-={'XYZ'},
Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}Date))"}>}Values )/10000000
LY:
Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)},COMPANY-={'XYZ'}
,Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-12))"}
>}Values )/10000000
Thanks,
Rohit
Hi,
If you have a year field, try max(year)-1
hi
try on this code, hope this helps you.
sum( {$<Year = {$(=Only(Year)-1)}>} Sales )
returns the sales for the previous year in relation to the current
selection. Here, a dollar-sign expansion is used to calculate
previous year.
********************************************************************************
sum(({<Year={$(=max(Year))},
Customer = p({<Year={$(=max(Year)-1)} Customer>}) Sales)
Returns this year’s sales for customers who had sales last year.
Hello everyone,
Thanx for the reply ..
I used the following codes.
CY:
SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},COMPANY-={'XYZ'},
Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}Date))"}>}Values )/10000000
LY:
Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)},COMPANY-={'XYZ'}
,Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-12))"}
>}Values )/10000000
Thanks,
Rohit