Wildmatch condition with Sum function

[Karthick30]

Hi,

I have a table like below

I need to sum all the value based on classification Prod and QA separately. I used below formula.

if(wildmatch(classification,'*Prod*'),Sum(Value ) .. my result should show as 2. likewise,

if(wildmatch(classification,'*QA*'),Sum(Value ) .. my result should show as 3. But its coming as expected. Its coming as -(null).

Am I doing anything wrong here

[MarcoWedel]

can you show the relevant part of your data model and describe where you apply this expression?

[Karthick30]

Yes. This is my actual Formula

Column has below data

measure value has multiple 1's in that column

[MarcoWedel]

I still did not understand the context that you apply this expression to, but I assume there is no CMDB_FinalBus.segment dimension involved.

So maybe rearranging your expression to

Sum(If(WildMatch([CMDB_FinalBus.segment],'*Residential*'), Remediated_Count))

 could work for you.

Or using a set expression instead:

Sum({$<[CMDB_FinalBus.segment]={"*Residential*"}>} Remediated_Count)

hope this helps

Marco