Expression Logic

[sona_sa]

Hi,

I have a pivot object. For data I have attached xls file, Please check. Now the issue is, For Total ODE --> ODE Class A Items + ODE Class B Items + Advertisement & Sales Promotion. My Calulation is not correct, Where In My Expression it is calculating like -->

ODE Class A Items + ODE Class B Items + Advertisement & Sales Promotion + Exchange (Gain) / Loss + Bad Debts (Which is wrong). It should be like --> ODE Class A Items + ODE Class B Items + Advertisement & Sales Promotion.

Expression :-

if(Match($(CurrentMonth),1),

if(match(Summury_Line_No,390),  (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),21))/((above(sum({<[Display Year]={$(PreviousYear)}>}  [Monthly Balance]),20))+above(sum({<[Display Year]={$(PreviousYear)}>}  [Monthly Balance]),24)),

    if(match(Summury_Line_No,400), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),22))/(above(sum({<[Display Year]={$(PreviousYear)}>}  [Monthly Balance]),14)),

        if(match(Summury_Line_No,410), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),23))/(above(sum({<[Display Year]={$(PreviousYear)}>}  [Monthly Balance]),11)),

            if(match(Summury_Line_No,380), (((above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),24) )+(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),25)))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),27)))*100,

(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]))/100000)

)))

,

if(match(Summury_Line_No,390),  (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),21)+above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),21))/(above(sum({<[Display Year]={$(PreviousYear)}>}  [Monthly Balance]),17)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>}  [Monthly Balance]),17)),

    if(match(Summury_Line_No,400), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),22)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),22))/(above(sum({<[Display Year]={$(PreviousYear)}>}  [Monthly Balance]),12)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>}  [Monthly Balance]),12)),

        if(match(Summury_Line_No,410), (above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),23)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),23))/(above(sum({<[Display Year]={$(PreviousYear)}>}  [Monthly Balance]),9)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>}  [Monthly Balance]),9)),

            if(match(Summury_Line_No,380), (((above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),24) - above(sum({<[Display Year]={$(PreviousYear)}, [Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),24))+(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),25)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),25)))/(above(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance]),27)-above(sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]),27)))*100,

(sum({<[Display Year]={$(PreviousYear)}>} [Monthly Balance])-sum({<[Display Year]={$(PreviousYear)},[Display Month Name]={$(PreviousMonth)}>} [Monthly Balance]))/100000)

)))

)

Please suggest what should to do.

Thanks.

[sona_sa]

Any expectation.