Skip to Content

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,

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.

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

Related questions

2 Answers

  • Best Answer
    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

  • author's profile photo Former Member
    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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.