12 Replies Latest reply: Apr 12, 2016 4:13 AM by naveen kumar RSS

    how to write percentage expression

    naveen kumar

      HI, I  am looking for this requirement ,

      this requirement is a level 2 requirement  , what i mean is after clicking on level 1 it will bring me to level2

      so category and decision filed are selected at level1 based up on that selection the level 2 shows only those supplier which full fill thet category and decision values

       

      level1 dimension:1)category

                                 2)decision

       

      expression

      =count({$<MaterialName=,YEAR=,QUATERS=,name1=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

       

      level2  dimension:1)name1

                                 2)decision

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

                                           2) percentage expression

         count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>}PRUEFLOS)

      /count({$<YEAR=,QUATERS=,ENSTEHDAT={">=$(vFromdate)<=$(vTodate)"}>} Total <name1>PRUEFLOS)

       

      i posted this requirement earlier , and some one had replied  me  with the above expression through which he is able to achieve my requirement as seen in below but when i tried using the same expression i am not getting the same out put 

       

       

      pastedImage_0.png

      pastedImage_1.png

      pastedImage_2.png

      please find my attached test file