11 Replies Latest reply: Apr 4, 2016 3:22 AM by Tatsiana Chetirbok RSS

    how to write dynamic expression

    naveen kumar

      Hello all , if i have a sample data like ,how to write a dynamics expression



      category  decision      material  lot

      smelting    accepted      spix      10

      smelting      rejected        spix      20

      smelting      exception      spix      30

      mining          accepted      hydra      25

      mining          rejected        hydra    35

      mining        exception      hydra      45


      so i need a dynamic  expression :   category={smelting},decision={accepted } and that particular material lot     =       10     in percentage

                                                        category={smelting}   total lot                                                                            (10+20+30)