Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to add number of subtypes if it contains a certain value, like "Noise" or "Animal" etc.
I've used the following expressions, but did not work
=Num(COUNT(WILDMATCH(SUBTYPE, 'NOISE')),'#,##0', ',')
//=IF(WILDMATCH(SUBTYPE, '*NOISE*'), NUM(COUNT(SUBTYPE),'#,##0', ','))
//=NUM(COUNT(wildMatch(text, ‘*Noise*’)))
Try
=Sum( Wildmatch(SUBTYPE, '*NOISE*') )
//Wildmatch returns zero if there is no match and 1 if the value is like '*NOISE*'
It would also be helpful to know the context of the expression.
Try
=Sum( Wildmatch(SUBTYPE, '*NOISE*') )
//Wildmatch returns zero if there is no match and 1 if the value is like '*NOISE*'
It would also be helpful to know the context of the expression.