Hi folks , i have gathered a quick summary of important differences between a calculate field and a roll up field:
Calculated Field | Roll Up Field |
Data is calculated as soon as form is loaded | The rollups are calculated by scheduled system jobs that run asynchronously in the background. |
calculated fields let you automate manual calculations used in your business processes. | . A rollup field contains an aggregate value computed over the records related to a specified record |
The calculated fields comprise of calculations that use the fields from the current entity or related parent entities. | The roll up fields comprise of Aggregation that use the fields from the current entity or related child entities. |
The expression support is available on the current entity and the related parent entity fields in the Condition sections and the Action sections. The built-in functions include:
ADDHOURS, ADDDAYS, ADDWEEKS, ADDMONTHS, ADDYEARS, SUBTRACTHOURS, SUBTRACTDAYS, SUBTRACTWEEKS, SUBTRACTMONTHS, SUBTRACTYEARS, DIFFINDAYS, DIFFINHOURS, DIFFINMINUTES, DIFFINMONTHS, DIFFINWEEKS, DIFFINYEARS, CONCAT, TRIMLEFT, and TRIMRIGHT. |
Wide selection of aggregate functions. You can aggregate data by using the following functions: SUM, COUNT, MIN, MAXand AVG. |
A seamless integration of the calculated fields with the forms, views, charts, and reports is available in real time. | eamless integration with the user interface. You can include the rollup fields in forms, views, charts and reports. |
The available data types for the calculated field: Single line of text,Option Set,Two Options,Whole Number,Decimal Number,Currency,Date and Time |
The data types include decimal or whole numbers, currency, and date/time. |
Above data has been collected from Microsoft technet.
if you wish to know more about these fields in-depth, please follow below:
Calculated Field : https://technet.microsoft.com/en-us/library/dn832103.aspx
Rollup Field : https://technet.microsoft.com/en-us/library/dn832162.aspx
Hope this helps!
Cheers!