Coding help??

[rohitians]

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

[#2]

Hi,

If you have a year field, try max(year)-1

[#3]

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.

[rohitians · Accepted solution]

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