Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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