AnsweredAssumed Answered

counting multiselect field in Sugar professional, 7.5.1.0

Question asked by Kelly Hu on Apr 17, 2015
Latest reply on Mar 31, 2017 by tuyet hoang
version: 7.5.1.0
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:

ifElse(equal($virtual_format,"Proposal"),multiply(count($product),3),count($product))

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?

Sincerely,
KH

Outcomes