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

Hi,

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

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

cell.JPG (47.4 kB)
##### Add a comment
10|10000 characters needed characters exceeded

### Related questions

Posted on Nov 07, 2012 at 06:09 AM

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

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 06, 2012 at 11:11 AM

Hi Sreenath,

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

Regards,

Deepak Chavan

##### Add a comment
10|10000 characters needed characters exceeded
• 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