ของความคิดเห็นเรื่องการปัดทศนิยม 2 ตำแหน่ง บวกคืนไม่เท่ากับ 100 ในการคิดร้อยละหน่อยครับ
จะเห็นว่า หลังจากปัดทศนิยมแล้ว ผลรวมจะหายไปบ้าง 99.99 บางชุดข้อมูลก็เกินเป็น 100.01 บ้างโค้ดที่ใช้ Code (PHP) <table id="document_summary" class="table table-bordered table-striped">
<thead>
<tr>
<th class="text-center">ไตรมาสที่</th>
<th class="text-right">จำนวน (บาท)</th>
<th class="text-right">ร้อยละ</th>
</tr>
</thead>
<tbody id="tbody_list">
<?php
$data_list_term = array ( 1 => 33510723.38, 2 => 18370386.71, 3 => 13147569.72, 4 => 20764823.03 );
//$data_list_term = array ( 1 => 16384952.27, 2 => 18174658.77, 3 => 16290075.46, 4 => 17268955.96);
$total_sum = array_sum($data_list_term);
$total_term = 0;
$total_percent = 0;
$total_loop = count($data_list_term);
$n=0;
foreach ($data_list_term as $term=>$total)
{
$n++;
$percent = round(($total * 100) / $total_sum, 2);
echo '<tr>
<td class="text-center">'.$term.'</td>
<td class="text-right">'. number_format($total, 2) .'</td>
<td class="text-right">'. number_format($percent, 2) .'</td>
</tr>';
$total_term += $total;
$total_percent += $percent;
}
?>
<tr>
<th class="text-center">รวม</th>
<th class="text-right"><?php echo number_format($total_term, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent, 2);?></th>
</tr>
</tbody>
</table>
Tag PHP
ประวัติการแก้ไข
Date :
2018-10-05 12:26:15By :
{Cyberman}View :
6985Reply :
16
ลองนะครับ$percent = ($total * 100) / $total_sum;
Date :
2018-10-05 13:36:34By :
Jatmentz
Date :
2018-10-05 13:44:21By :
{Cyberman}
https://stackoverflow.com/questions/11114861/php-adding-2-decimal-points-numbers-money-gives-wrong-results-in-total-amount http://php.net/bcmath echo round(3.4); // 3
echo round(3.5); // 4
echo round(3.6); // 4
echo round(3.6, 0); // 4
echo round(1.95583, 2); // 1.96
echo round(1241757, -3); // 1242000
echo round(5.045, 2); // 5.05
echo round(5.055, 2); // 5.06
echo round(9.5, 0, PHP_ROUND_HALF_UP); // 10
echo round(9.5, 0, PHP_ROUND_HALF_DOWN); // 9
echo round(9.5, 0, PHP_ROUND_HALF_EVEN); // 10
echo round(9.5, 0, PHP_ROUND_HALF_ODD); // 9
echo round(8.5, 0, PHP_ROUND_HALF_UP); // 9
echo round(8.5, 0, PHP_ROUND_HALF_DOWN); // 8
echo round(8.5, 0, PHP_ROUND_HALF_EVEN); // 8
echo round(8.5, 0, PHP_ROUND_HALF_ODD); // 9
https://stackoverflow.com/questions/13483430/how-to-make-rounded-percentages-add-up-to-100 https://stackoverflow.com/questions/21581341/how-to-round-half-on-a-set-of-numbers-which-sum-to-100
ประวัติการแก้ไข
Date :
2018-10-05 13:59:23By :
apisitp
ตรวจสอบข้อมูล ถ้า เกิน 100.00 เช่น 100.01 ให้ลบรายการสุดท้าย ออก 0.01
Date :
2018-10-05 15:01:53By :
Chaidhanan
ลองดูแบบนี้ไหมครับ round(num, 1)
Date :
2018-10-05 15:35:37By :
Jatmentz
การกำหนดจุดทศนิยม มีคำสั่งให้ใช้หลากหลายครับ
Date :
2018-10-05 21:40:30By :
djunghoo
ลองทั้ง PHP_ROUND_HALF_EVEN และ PHP_ROUND_HALF_ODD ก็ยังไม่ได้ครับhttp:// https://phpfiddle.org/ Code (PHP) <style>table table{
border-spacing: 5px;
border-collapse: collapse;
}
table table td, table table th{
border: 1px solid black;
}
</style>
<table border="1" cellpadding="10">
<tr>
<td>ปัดทศนิยม 2 ตำแหน่ง</td>
<td>ปัดทศนิย 2 ตำแหน่ง ด้วย PHP_ROUND_HALF_EVEN</td>
<td>ปัดทศนิย 2 ตำแหน่ง ด้วย PHP_ROUND_HALF_ODD</td>
</tr>
<tr>
<td>
<table id="document_summary" class="table table-bordered table-striped">
<thead>
<tr>
<th class="text-center">ไตรมาสที่</th>
<th class="text-right">จำนวน (บาท)</th>
<th class="text-right">ร้อยละ</th>
</tr>
</thead>
<tbody id="tbody_list">
<?php
$data_list_term = array ( 1 => 33510723.38, 2 => 18370386.71, 3 => 13147569.72, 4 => 20764823.03 );
$total_sum = array_sum($data_list_term);
$total_term = 0;
$total_percent = 0;
$total_loop = count($data_list_term);
$n=0;
foreach ($data_list_term as $term=>$total)
{
$n++;
$percent = round(($total * 100) / $total_sum, 2);
echo '<tr>
<td class="text-center">'.$term.'</td>
<td class="text-right">'. number_format($total, 2) .'</td>
<td class="text-right">'. number_format($percent, 2) .'</td>
</tr>';
$total_term += $total;
$total_percent += $percent;
}
?>
<tr>
<th class="text-center">รวม</th>
<th class="text-right"><?php echo number_format($total_term, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent, 2);?></th>
</tr>
</tbody>
</table>
<br/>
<table id="document_summary" class="table table-bordered table-striped">
<thead>
<tr>
<th class="text-center">ไตรมาสที่</th>
<th class="text-right">จำนวน (บาท)</th>
<th class="text-right">ร้อยละ</th>
</tr>
</thead>
<tbody id="tbody_list">
<?php
$data_list_term = array ( 1 => 16384952.27, 2 => 18174658.77, 3 => 16290075.46, 4 => 17268955.96);
$total_sum = array_sum($data_list_term);
$total_term = 0;
$total_percent = 0;
$total_loop = count($data_list_term);
$n=0;
foreach ($data_list_term as $term=>$total)
{
$n++;
$percent = round(($total * 100) / $total_sum, 2);
echo '<tr>
<td class="text-center">'.$term.'</td>
<td class="text-right">'. number_format($total, 2) .'</td>
<td class="text-right">'. number_format($percent, 2) .'</td>
</tr>';
$total_term += $total;
$total_percent += $percent;
}
?>
<tr>
<th class="text-center">รวม</th>
<th class="text-right"><?php echo number_format($total_term, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent, 2);?></th>
</tr>
</tbody>
</table>
</td>
<td>
<table id="document_summary" class="table table-bordered table-striped">
<thead>
<tr>
<th class="text-center">ไตรมาสที่</th>
<th class="text-right">จำนวน (บาท)</th>
<th class="text-right">ร้อยละ</th>
<th class="text-right">ร้อยละ</th>
</tr>
</thead>
<tbody id="tbody_list">
<?php
$data_list_term = array ( 1 => 33510723.38, 2 => 18370386.71, 3 => 13147569.72, 4 => 20764823.03 );
$total_sum = array_sum($data_list_term);
$total_term = 0;
$total_percent = 0;
$total_loop = count($data_list_term);
$n=0;
$total_percent_4 = 0;
foreach ($data_list_term as $term=>$total)
{
$n++;
$percent_4 = ($total * 100) / $total_sum;
$total_percent_4 += $percent_4;
$percent = round(($total * 100) / $total_sum, 2, PHP_ROUND_HALF_EVEN);
echo '<tr>
<td class="text-center">'.$term.'</td>
<td class="text-right">'. number_format($total, 2) .'</td>
<td class="text-right">'. number_format($percent_4, 4) .'</td>
<td class="text-right">'. number_format($percent, 2) .'</td>
</tr>';
$total_term += $total;
$total_percent += $percent;
}
?>
<tr>
<th class="text-center">รวม</th>
<th class="text-right"><?php echo number_format($total_term, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent_4, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent, 2);?></th>
</tr>
</tbody>
</table>
<br/>
<table id="document_summary" class="table table-bordered table-striped">
<thead>
<tr>
<th class="text-center">ไตรมาสที่</th>
<th class="text-right">จำนวน (บาท)</th>
<th class="text-right">ร้อยละ</th>
<th class="text-right">ร้อยละ</th>
</tr>
</thead>
<tbody id="tbody_list">
<?php
$data_list_term = array ( 1 => 16384952.27, 2 => 18174658.77, 3 => 16290075.46, 4 => 17268955.96);
$total_sum = array_sum($data_list_term);
$total_term = 0;
$total_percent = 0;
$total_loop = count($data_list_term);
$n=0;
$total_percent_4 = 0;
foreach ($data_list_term as $term=>$total)
{
$n++;
$percent_4 = ($total * 100) / $total_sum;
$total_percent_4 += $percent_4;
$percent = round(($total * 100) / $total_sum, 2, PHP_ROUND_HALF_EVEN);
echo '<tr>
<td class="text-center">'.$term.'</td>
<td class="text-right">'. number_format($total, 2) .'</td>
<td class="text-right">'. number_format($percent_4, 4) .'</td>
<td class="text-right">'. number_format($percent, 2) .'</td>
</tr>';
$total_term += $total;
$total_percent += $percent;
}
?>
<tr>
<th class="text-center">รวม</th>
<th class="text-right"><?php echo number_format($total_term, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent_4, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent, 2);?></th>
</tr>
</tbody>
</table>
</td>
<td>
<table id="document_summary" class="table table-bordered table-striped">
<thead>
<tr>
<th class="text-center">ไตรมาสที่</th>
<th class="text-right">จำนวน (บาท)</th>
<th class="text-right">ร้อยละ</th>
<th class="text-right">ร้อยละ</th>
</tr>
</thead>
<tbody id="tbody_list">
<?php
$data_list_term = array ( 1 => 33510723.38, 2 => 18370386.71, 3 => 13147569.72, 4 => 20764823.03 );
$total_sum = array_sum($data_list_term);
$total_term = 0;
$total_percent = 0;
$total_loop = count($data_list_term);
$n=0;
$total_percent_4 = 0;
foreach ($data_list_term as $term=>$total)
{
$n++;
$percent_4 = ($total * 100) / $total_sum;
$total_percent_4 += $percent_4;
$percent = round(($total * 100) / $total_sum, 2, PHP_ROUND_HALF_ODD);
echo '<tr>
<td class="text-center">'.$term.'</td>
<td class="text-right">'. number_format($total, 2) .'</td>
<td class="text-right">'. number_format($percent_4, 4) .'</td>
<td class="text-right">'. number_format($percent, 2) .'</td>
</tr>';
$total_term += $total;
$total_percent += $percent;
}
?>
<tr>
<th class="text-center">รวม</th>
<th class="text-right"><?php echo number_format($total_term, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent_4, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent, 2);?></th>
</tr>
</tbody>
</table>
<br/>
<table id="document_summary" class="table table-bordered table-striped">
<thead>
<tr>
<th class="text-center">ไตรมาสที่</th>
<th class="text-right">จำนวน (บาท)</th>
<th class="text-right">ร้อยละ</th>
<th class="text-right">ร้อยละ</th>
</tr>
</thead>
<tbody id="tbody_list">
<?php
$data_list_term = array ( 1 => 16384952.27, 2 => 18174658.77, 3 => 16290075.46, 4 => 17268955.96);
$total_sum = array_sum($data_list_term);
$total_term = 0;
$total_percent = 0;
$total_loop = count($data_list_term);
$n=0;
$total_percent_4 = 0;
foreach ($data_list_term as $term=>$total)
{
$n++;
$percent_4 = ($total * 100) / $total_sum;
$total_percent_4 += $percent_4;
$percent = round(($total * 100) / $total_sum, 2, PHP_ROUND_HALF_ODD);
echo '<tr>
<td class="text-center">'.$term.'</td>
<td class="text-right">'. number_format($total, 2) .'</td>
<td class="text-right">'. number_format($percent_4, 4) .'</td>
<td class="text-right">'. number_format($percent, 2) .'</td>
</tr>';
$total_term += $total;
$total_percent += $percent;
}
?>
<tr>
<th class="text-center">รวม</th>
<th class="text-right"><?php echo number_format($total_term, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent_4, 2);?></th>
<th class="text-right"><?php echo number_format($total_percent, 2);?></th>
</tr>
</tbody>
</table>
</td>
</tr>
</table>
</table>
Date :
2018-10-06 08:00:39By :
{Cyberman}
อธิบายเพิ่มเติมครับ
Date :
2018-10-06 16:23:52By :
djunghoo
Server 03
Load balance : Server 03
