|Feature||Trigger||Execution||Client / Server||Scope||Conditions||Fields||Functions||Limits||Usage|
|Synchrounous / Real Time|
Finally: Business Rules
|Client: Specific Forms/ All Forms/|
|Rollup Fields||On Save / Every 1-12 hours / When User Presses Rollup Refresh Button||Asynchronous / Every 1-12 hours|
Rollups are calculated by scheduled system jobs Settings > System Jobs > View > Recurring System Jobs. System Job type: Mass Calculate Rollup Field or Calculate Rollup Field
|Server||Related Entity / Parent Child Relationship Upto 1 Level Deep||And / OR, not a mixure||Whole Number|
|SUM / MAX / MIN / COUNT / AVG||Cannot use other Calculated or Rollup fields as part of a rollup.||Aggregate calculations of child entities. The difference between Calculated Fields is Rollup fields are not virtual, they are physical attributes. Such as no. of open opportunities, activities, revenue, etc.|
|Calculated Fields||OnSave||Synchronous||Server||Entity/ Parent Child Relationship Upto1 Level Deep||AND or OR , Not a mix of both||ADDHOURS, |
TRIMLEFT, and TRIMRIGHT.
|Two calculated fields cannot reference each other in their formulas|
Floating point numbers cannot be used in calculated fields.
Won’t trigger workflow updates
Fields are virtual /not stored at the database level
Calculated fields can calculate based on other fields, including rollup fields and other calculated fields.
RAJEEV KUMAR, Azure Architect, Azure Data Engineer, AZURE Developer, Prince2®, SAFe®, CSM®, ITIL® (Linkedin: www.linkedin.com/pub/rajeev-kumar/13/459/663)
Monday, July 24, 2017
Business Rules Vs Rollup Fields Vs Calculated Fields
Subscribe to: Post Comments (Atom)
Get files of last hour in Azure Data Factory
Case I have a Data Factory pipeline that should run each hour and collect all new files added to the data lake since the last run. What is...
Microsoft Dynamics CRM supports two types of parameters for a workflow activity. Input Parameters Output Parameters Input Paramete...
I find that using workflow id might be problematic across deployment, so I wrote a function to retrieve workflow’s guid given the workflow...
Post a Comment