Hi all,
I have created roll up field in CRM 2016, average is 4.667 it is not rounding up and coming as 4.
Please let me know do we have any OOB in CRM.
Thanks,
*This post is locked for comments
Hi,
It always depend on precision of the Aggregated field.
If the precision of the aggregated field is greater than the precision of the rollup field, the aggregated field precision is rounded down to the precision of the rollup field, before the aggregation is performed. To illustrate this behavior, let’s look at a specific example. Let’s say that the rollup field on the account entity, for calculating the total estimated revenue of the related opportunities, has a precision of two decimal points. The Est. Revenue field on the opportunity entity is the aggregated field with the precision of four decimal points. In our example, the account has two related opportunities. The aggregated sum of the estimated revenue is calculated as follows:
Est. Revenue for the first opportunity: $1000.0041
Est. Revenue for the second opportunity: $2000.0044
Aggregated sum of Est. Revenue: $1000.00 + $2000.00 = $3000.00
As you can see, the precision rounding to two decimal points on the aggregated field is done before the aggregation is performed.
For more details check
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
