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

# How to set expression with more "Dimensions"

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.."?

• ###### Re: How to set expression with more "Dimensions"

try this, double quote, *

sum({<[Mjesto troška]={"SP0*"}>} NETO)

• ###### Re: How to set expression with more "Dimensions"

Works. thank you

• ###### Re: How to set expression with more "Dimensions"

you can find previous answer and a lot of others in the very good doc of Aunez Fabrice, here

Set Analysis: syntaxes, examples