3 Replies Latest reply: Feb 17, 2014 5:50 AM by Massimo Grossi RSS

    How to set expression with more "Dimensions"

    Kristian König

      Hello,

       

      i have this expression:

       

      sum({<[Mjesto troška]={'SP0101'}>} NETO)-sum({<[Mjesto troška]={'SP0101'}>} NBVR)

       

      this expression calculates the Profit where Mjesto troška is "SP0101"

       

      Now, i have more Mjesto troška that i would like to include. They all start with SP0.. and then 101,102,103, 201,202,203.. and so on...

      This would be unnecessary code to integrate all the Mjesto troška for itself...

       

      Is there a formula like "begins with(excel)" sum the Profit where Mjesto troška begins with "SP0.."?

       

      Thank you in advance for your help