Calculated fields with clauses

Hi Frederik Lundberg,

I would address this with a formula like this:

countConditional($members,'status',array('Rented'))

This works as expected for me:

countConditional($members,"account_type",createList("Customer","Investor"))

I hope this helps!

Hi Patrick McQueen,

I tried this already with the account_type list in SugarCRM Enterprise 8.3.0 (demo environment)

When I replace the field name with the variable it seems to accept this but 'Customer' is an issue in any combination (looks like lists are not working here:

With "array()"

Without "array()"

Next try with double quotes the formula is accepted

but ends in an error 500 on opening accounts

With "array()" and double quotes

Looks like we have a bug here or formulas with dropdowns doesn't work.

Any idea or should we raise a bug report?

Bests

Björn

Hi Patrick McQueen,

I tried this already with the account_type list in SugarCRM Enterprise 8.3.0 (demo environment)

When I replace the field name with the variable it seems to accept this but 'Customer' is an issue in any combination (looks like lists are not working here:

With "array()"

Without "array()"

Next try with double quotes the formula is accepted

but ends in an error 500 on opening accounts

With "array()" and double quotes

Looks like we have a bug here or formulas with dropdowns doesn't work.

Any idea or should we raise a bug report?

Bests

Björn

Hi Björn Canales Pfisterer,

I apologize my earlier advice was inaccurate.

This works as expected for me:

countConditional($members,"account_type",createList("Customer","Investor"))

1. You are correct the $field_name, not 'field_name' works here.

2. array() is not a function of calculated fields.

There are defects in the help text description for the countConditional() function. We have in our records Defect 80244 outlining this and communicating the workaround.