How to set expression with more "Dimensions"

[#1]

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

[maxgro · Accepted solution]

try this, double quote, *

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

[#3]

Works. thank you

[maxgro]

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

Set Analysis: syntaxes, examples