I am working on a sharepoint server 2016. and i have a custom list with the following fields:-
i am showing sample of a test data with a test column names, as these info is somehow confidential.
now as shown in the above picture, i am getting a value of
-6,999,95999999, which is a result of the following calcualtion:-
(5250 * 12 * 1) - (5833.33 * 12 * 1 )
now using the calculator on my windows machine, the result will be
-6999.96 .. so why inside my sharepoint calculated column i am getting
also if i change the number
4833.33 i will get a correct result without extra decimals as follow:-
which is the result of the following equation :-
(5250 * 12 * 1) - (4833.33 * 12 * 1 )
so is there a way to avoid unwanted decimals and why there are showing on certain scenarios only? keeping in mind that all the numeric fields i am using and all the calculated columns are of type numeric and have automatic number of decimals..