31 Replies Latest reply: Apr 12, 2016 2:27 AM by naveen kumar RSS

    how to write expression for percentage

    naveen kumar

      Hello All,

      suppose if i have a table data like this

       

       

       

       

       

       

          supplier     accepted   rejected   exception accepted        total                ENSTEHDAT

            a                  50              25                 25                    100               10/03/2015

             a                100             50                 50                    200               15/004/2015 

           b                   25             25                50                    100               10/03/2015

             b                  50              25                25                    100                15/004/2015 




      what my requirement is i want known what percentage of  each supplier lots were accepted,rejected, exception from total for that particular period

      i mean suppose i select date range from 01/03/2015 to 01/05/2015,and accepted value from decision field   then i should see

                                     


                                                                  accepted=   150(50%)    (out of 300)         75(40%)  (out of 200)     

                                                                                              a                                  b


                                                                

          rejected value from decision field rejected= 75(25%)    (out of 300)         50(20%)  (out of 200)     

                                                                                          a                                  b



      exception accepted value from decision field exception accepted=   75(25%)    (out of 300)         75(40%)  (out of 200)     

                                                                                                                                     a                                  b





      so in a bar chart if i take two dimension:1)supplier

                                                                 2)decision (as values accepted, rejected ,exception accepted)



                      expression   :1)=count({$<YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>total)

                                           2)percentage?

       

       

       

      thanks

      naveen