Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this, double quote, *
sum({<[Mjesto troška]={"SP0*"}>} NETO)
Works. thank you
you can find previous answer and a lot of others in the very good doc of Aunez Fabrice, here