Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarvenkategow
Contributor
Contributor

Set Analysis Expression retunes zero

Here is my expression : Sum({<description={'$(Vtrend2)'}>}value)

Variable: =SubField(GetFieldSelections(description),',',2)

i have added description as the filter and selecting the two values in the filter

its retuning as 0 , while I expect more than 0. please help.

Labels (1)
3 Replies
MayilVahanan

Hi

Variables will return only 2nd description, is it ur requirement like that? or u want to display all the selected description info?

for all selected description, try like below

Variable: = If(GetselectedCount(description) > 0, Concat(DISTINCT chr(39)&description, chr(39)&',')&chr(39))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
sagarvenkategow
Contributor
Contributor
Author

Hi @MayilVahanan 

Variables will return only 2nd description, so in the set analysis i am trying to set that value.

MayilVahanan

In that case, did you check the variable - "Vtrend2" values whether it's assigning the correct value or not. And also, confirm those has values or not.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.