Average % result wrong
CompletedHello Comunity
I'm trying to average one percent field of a sublist.
I do this with the function Calcualted Value - Average value....
The fields in both lists are configured the same.
The result is wrong by 3 decimal places. So 0.1 instead of 100
Anybody got an idea?
0
-
You're right, the field calculation doesn't work properly for number fields with percentage formatting. It's shifted by two decimal places (factor 100) as SharePoint stores percentage values in this format.
We will fix this and let you know here as soon it's released. Thank you for this feedback!
0
Please sign in to leave a comment.
Comments
1 comment