SharePoint List changing percentage value after input
Hi,
We have a SP List incorporated on out SP site to collect data.
Two of the column are formatted as Number columns with “Show as percentage” checked.
For the past two months, input was as expected.
When we enter value: 74, in the Form; 74% is displayed in the list.
As of June 08, 2024 the behavior of the column in the List has changed.
Now, if we enter the same value of: 74, in the Form, it displays as: 0,74%. (or just 0,5% depending on how may decimal places we use)
When we troubleshoot, no explanation can be found for this error.
Also, historical data from previous months is unchanged and still shows a whole number in percent.
We have also tried to add a new Number column, showing as percentage, and the error still prevails.
Footnote: After submitting the Form, for a second only, 74% is shown before it changes to 0,74% in the List. view.
I should mention that the list is used in a PowerBI report.
Have there been any changes to SP List or could the PowerBI formatting override the List column formatting?
Hi, We have a SP List incorporated on out SP site to collect data. Two of the column are formatted as Number columns with “Show as percentage” checked. For the past two months, input was as expected.When we enter value: 74, in the Form; 74% is displayed in the list.As of June 08, 2024 the behavior of the column in the List has changed. Now, if we enter the same value of: 74, in the Form, it displays as: 0,74%. (or just 0,5% depending on how may decimal places we use) When we troubleshoot, no explanation can be found for this error. Also, historical data from previous months is unchanged and still shows a whole number in percent. We have also tried to add a new Number column, showing as percentage, and the error still prevails. Footnote: After submitting the Form, for a second only, 74% is shown before it changes to 0,74% in the List. view. I should mention that the list is used in a PowerBI report. Have there been any changes to SP List or could the PowerBI formatting override the List column formatting? Read More
