Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
substringcount(concat(%dim3,'|'),fullname) and get selectedcount(%dim3)<>0
here what it do ? i know work functionality of concat but here quite different what it do here?
Hi,
Part 1
substringcount(concat(%dim3,'|'),fullname)
To count with or without any selection
Part 2
getselectedcount(%dim3)<>0
To count for Selection, This condition here means there must be some selected values
Hope it helps
Regards
ASHFAQ
Yhe first expression count how many "fullname" there are in the string composed by %dim3 while the second expresion count how many values you have selected in field %dim3
it means how many full names are there in the %Dim3 or in the string selections of %Dim3
First one counts the full names while second one that is getselectedcount(%dim3)<>0 is a condition which checks how many value selected in the %dim3. And it is worked only where there is some value selected in the field %dim3 at least one value.
Regards
Anand
The first expression (Used in a object, not in the script) returns all the values for selected field depending on the expresion, so the result can be different from the second expression
it counts the no of full names in %dim3 ? OR selections of %dim3 pls tell me
If you will select anything for %dim3, then it work work over that select set of data, otherwise if nothing is selected it will traverse over all values of %dim3.
Hope this was helpful.
Thanks,
Singh
Hi,
Part 1
substringcount(concat(%dim3,'|'),fullname)
To count with or without any selection
Part 2
getselectedcount(%dim3)<>0
To count for Selection, This condition here means there must be some selected values
Hope it helps
Regards
ASHFAQ