Error in expression

[#1]

=sum(if(Index(GetFieldSelections(Medication_Tree),Concat('Cost.Sub_Cost_Category1 and  Cost.Sub_Cost_Category2')>0),1,0))

[sushil353]

Hi Hammad,

Could you explain what r u trying to do with the above expression.

HTH

Sushil

[SunilChauhan]

try this

sum(if(Index(GetFieldSelections(Medication_Tree),('Cost.Sub_Cost_Category1 & Cost.Sub_Cost_Category2')>0),1,0))

[#4]

A bit of context would be good

[jonathandienst]

Hi

Concat is an aggregation function, not a string concatenation operator. Use & for this. But in your case, if I correctly understand what you are trying to do, I suggest that you use WildMatch:

=sum(if(WildMatch(GetFieldSelections(Medication_Tree), '*Cost.Sub_Cost_Category1*', '*Cost.Sub_Cost_Category2*') > 0), 1, 0)

(count 1 if one or both of the strings are in the selection(s) for Medication_Tree)

HTH

Jonathan