SuiteCRM Fields Calculation

Grow your business using Calculated Fields to automate manual calculations and reduce code for complex calculations

Key Product Features

• Automate your manual calculations used in your business production
• Create a field in your formula for dynamic calculations
• Available Functions : Add, Subtract, Multiply, Divide, String Length, Concatenation, Log (Logarithm), Ln (Natural Log), Absolute, Average, Power, Date Difference, Percentage, Mod (Modulo), Minimum, Negate, Floor, Ceil, Add hours, Add day, Add week, Add month, Add year, Sub hours, Sub days, Sub week, Sub month, Sub year, Diff days, Diff hour, Diff minute, Diff month, Week Diff, Diff year
• Calculation on Related Fields
• Date Functions: ADDHOURS, ADDDAYS, ADDWEEKS, ADDMONTHS, ADDYEARS, SUBTRACTHOURS, SUBTRACTDAYS, SUBTRACTWEEKS, SUBTRACTMONTHS, SUBTRACTYEARS, DIFFINDAYS, DIFFINHOURS, DIFFINMINUTES, DIFFINMONTHS, DIFFINWEEKS, DIFFINYEARS
• A rich conditional support we provide: you can make a big calculation here, a nested formula
• You can insert manual value or Field, or both together to create a formula. For e.g. add(field1,200,sub(100,field2))
• You can use calculated field also to make further formula

How it Works

• Download and Install the plugin Admin-> Module Loader -> Upload & Install ‘SuiteCRM Calculated Fields’ -> Configure your License
• Configure your license first Admin-> SuiteCRM Calculated Fields -> License Configuration

• After Configuring your License Admin -> Repair -> Do 'Quick Repair & Rebuild'

• Studio -> 'Module' -> Add Fields -> Select 'Data Type' : Calculated Field

• Click ‘Edit Formula’ to write your formula

• Result of the above formula

• Calculate Percentage

• Result of Percentage Formula

• Calculate Date Difference

• Result of Date Difference

• Concatenation Example

• Result of Concatenation

• Calculate Subtract Month

• Result of Subtract Month

• Calculate Difference Minute

\

• Result of Minute Difference