Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=sum(if(Index(GetFieldSelections(Medication_Tree),Concat('Cost.Sub_Cost_Category1 and Cost.Sub_Cost_Category2')>0),1,0))
Hi Hammad,
Could you explain what r u trying to do with the above expression.
HTH
Sushil
try this
sum(if(Index(GetFieldSelections(Medication_Tree),('Cost.Sub_Cost_Category1 & Cost.Sub_Cost_Category2')>0),1,0))
A bit of context would be good
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