Calculations

[henryvho]

Hi,

I have several interger and decimal in the contacts tab.

Fields such as current_balance and available_balance. Both are in decimal.

Is there a way I can create a new field called "balance_ratio" in SugarCRM which automatically divides the two fields current_balance/available_balance and show the percentage on a "ListView" layout?

I sincerely appreciate your support. Sugar is AWESOME!!!

Thanks,
Henry

[davidboris]

Hello,

If you want such kind of facility in ListView ONLY,then
1) Create a non-db field by extending vardefs.
2) Create a logic_hook (process_record) and assign a value to it.


If you want to create a custom field then
1) Save value in before_save logic_hook,
2) Put it in listview via studio.

[clint]

In Sugar Professional and Sugar Enterprise, we now have since Sugar 6.2 a new "Calculated Field" attribute on the field inside of Studio that allows you to easily write the expression that you just described. What henryvho is also absolutely correct and will work in all editions of Sugar. This new Calculated Field mechanism simplifies this process for Pro and Enterprise users.

[item]

In Sugar Professional and Sugar Enterprise, we now have since Sugar 6.2 a new "Calculated Field" ...This new Calculated Field mechanism simplifies this process for Pro and Enterprise users.

Hi Clint,
Happy to know that a new type of field is born for sugarcrm 6.2 "PRO" and "ENT"
god save this field type and sorry for CE

Regards.