Expression Help

[sona_sa]

Hi,

Can anyone help me on below expression.

I have my expression - sum(aggr( Fabs((Sum(SALES_QTY) - Sum(SOP_Cts))/1000), CATEGORY))

Now With some condition I have to change in

If(Year ='2014',(sum({$<Year = {2013,2014},MONTH = {"<=$(vMonth)"},HalfYear,Quarter>} SALES_AMT_USD/1000000)),

If(Year = '2013',(sum({$<Year={2013},MONTH = {7,8,9,10,11,12},HalfYear,Quarter>}SALES_AMT_USD)/1000000),

(Sum(SALES_AMT_USD)/1000000)))

Previous one I have to convert in

If(Year ='2014',(sum({$<Year = {2013,2014},MONTH = {"<=$(vMonth)"},HalfYear,Quarter>} SALES_AMT_USD/1000000)),

If(Year = '2013',(sum({$<Year={2013},MONTH = {7,8,9,10,11,12},HalfYear,Quarter>}SALES_AMT_USD)/1000000),

(Sum(SALES_AMT_USD)/1000000)))

Thanks

[MK_QSL]

Can you tell me how you achieve below?

1/5-COLL DLX - W 2

0.3480

1.3328

0.9848

[sona_sa]

finished from my side. OK Thanks