8 Replies Latest reply on Aug 24, 2016 1:43 PM by Joe Oppelt

    Incorrect % Calculation when  filter is selected

    POTHURAJU BOLEM

      Hi ,

       

      I have a requirement to show the percentage  of Regulation based on the total number of records and this coulmn will always two values like SOX and MON.when i have selected both values in the filter result of percentage is showing correct whenever i have selected a single value out of Two values (SOX and Mon) then it is showing 100% .

       

      Below is the example :

       

      Total Records are  : 37

      SOX is  : 21 , percentage of total is - 57%

      MON is : 16 , Percentage of total is : 43%

       

      if i have selected both the values, result  of  % is showing correct  and if i am selecting the either of the value the result of % is showing 100% which is incorrect , instead of 57% or 43% respective selection criteria.

       

       

      Appreciate your Quick help !!!.

       

      Thanks a lot for your help .

       

      Message was edited by: POTHURAJU BOLEM