Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is more of just a curiosity but
I used to use
SubStringCount(GetFieldSelections([Column Name], ',' ,Count(Distinct [Column Name])), 'Item')
I think that the Count(Distinct [Column Name]) is returning a different value (type?) than it used to.
Although if I create a variable with
=Count(Distinct [Column Name]) and then reference it like this
SubStringCount(GetFieldSelections([Column Name], ',' ,$myvariable), 'Item')
then it works, strange
Any thoughts?
-Michael
Hi Michael,
It seems it only accepts numeric values, and although Count() will return a numeric value it's not itself a number. That will work as expected as well with the dollar expansion
SubStringCount(GetFieldSelections([Column Name], ',', $(=Count(Distinct [Column Name]))), 'Item')
That happened in version 10 SR3 update 9061 with the Min() function, when the thrid parameter must be a numeric value instead of an expression returning a numeric value. I use the dollar expansion/macro expansion $(=) there as well.
Hope that makes some sense.
Miguel