SuiteCRM 8 Calculation Field

Grow your business using Calculated Fields to automate manual calculations and lessen the code for complex calculations.

Key Product Features

• Calculated Fields let you automate your manual calculations used in your business production.
• You can give 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
• 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

Product Screenshots

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

Get in Touch

For support or any questions: Email us at info@techesperto.com