Skip to Content
author's profile photo Former Member
Former Member

RE : How to Calculate Row and Coloumn Count from different blocks in webi

Posted on Jan 16, 2017 at 08:27 AM 39 Views

Hi,

We have created a report in webi Rich client, As per requirement we have different unit of measures and created report with different blocks and applied conditional formatting with colors (R/G/Y) by applying Threshold values. Now the requirement is to Calculate Row and Column count and display them as Percentages how many Reds/ greens/Yellows in both Row and Column of the report. For example : Row Count it should count how many R/Y/G from different blocks( As we have different unit of measures and created report with different blocks) and display them as percentages. How to calculate the count of colors (R/G/Y) in different blocks and in a single table with all the blocks included in it? Please find the attached Sample Screen shot.

v9uem.png (14.1 kB)
SAP Knowledge Acceleration, version for SAP BusinessObjects Web Intelligence
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Jyothirmayee A
    Jyothirmayee A
    Posted on Feb 15, 2017 at 08:56 PM

    Hi,

    Your color conditional formatting is dependent on Unit of Measures. Create a similar variable that shows a color Yellow and apply count to it. In that sense you are logically counting color Yellow. Just a thought.

    Post a sample data or condition that you used for color formatting.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded