search substring in set analysis

[#1]

hi everybody

i have this expression in a pivot table :

sum( {$ < TASK_NAME="*mantis*") >} [ACTUAL])

but i would have ACTUAL for all TASK with TASK_NAME contains substring mantis. How i can do that i try * 😕

[#2]

Hi there,

your search mask should work fine. Did you copy/paste your expression? Then check for the ')' after your searchmask. Seems to be too much.

Hope thats it 😉

Roland

[#3]

Hi it should work

sum( {$<TASK_NAME= {" *mantis* "}>} [ACTUAL] )

[#4]

Hi Luca, you are right. The {} to include the searchmask are also missing!

RR

[#5]

thx for your answers

sum( {$<TASK_NAME= {"*mantis*"}>} [ACTUAL] ) make the job;) just a syntax error