how to show values only for the current month in cell's of bex

[sreenath_adapa]

Hi,

i have a requirement to show only current month data in a cell where it had some calculations over the cell,

Year	Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9
	April	May	June	July	Aug	Sep	Oct	Nov	Dec
2012	20	20	20	20	20	20	20	20	20
2011	10	10	10	10	10	10	10	10	0
Variance(2011-2012)	-10	-10	-10	-10	-10	-10	-10	-10	-20

In the above table 2012-Row 1 represents current financial year and 2011-Row 2 represents Previous financial year and row

Variance(2011-2012) represents ( row 1-row 2 ) .

My requirement is to show only the values in current month for the current month variance(AS GREEN COLOURED). i don't want to show the other months values in variance(RED).

Because of the complexity in the report we have gone through with the CELL's in reporting.

Please go through with the below structure in BEX Query

somebody please help me how this can be done.

[sreenath_adapa · Accepted solution]

I am thinking in such way if i create one more Row

which gives values according to the 0Calmonth2 as current month =1 and remaining months = 0

and if i multiply Variance row with The new row

Where it will show values only for the current month and remaining as "0"

2012	20	20	20	20	20	20	20	20	20
2011	10	10	10	10	10	10	10	10	0
Variance(2011-2012)	-10	-10	-10	-10	-10	-10	-10	-10	-20
New Row	0	0	0	0	0	0	0	1	0

in Variance i will put (2012-2011)* New row

out put will be as follows

2012	20	20	20	20	20	20	20	20	20
2011	10	10	10	10	10	10	10	10	0
Variance(2011-2012)	0	0	0	0	0	0	0	-10	0

this is what i need , But going for this How can i maintain 1 for only current month every time and

for remaining months as 0's.

help PlZ

Sreenath

[sreenath_adapa · Accepted solution]

I got It.

[Former Member]

Hi Sreenath,

Can you please check if you can restrict the Variance with 0curmonth variable.

Regards,

Deepak Chavan

[sreenath_adapa]

Thank You for the mail Mr. Deepak

As the Variance field is calculated on runtime we are using CKF's so i am unable to go for what you said.

Thanks,

Sreenath