AnsweredAssumed Answered

counting multiselect field in Sugar professional,

Question asked by Kelly Hu on Apr 17, 2015
Latest reply on Mar 31, 2017 by tuyet hoang
edition: SugarCRM Professional

I have a multi-select dropdown field ($product) in one of my modules. I want to add a new field that will display how many items have been selected in Product if the project type is proposal. Here's how I built the formula to calculate the value:


For some reason, what I actually see on the page in this new field is either number 1 or 0.

Can someone please help me figure this out? Can it be that Sugar cannot perform calculations on values captured from the multi-select?