# 条件つきの合計値計算

**URL:** <https://forum.kintone.dev/t/topic/355>\
**Category:** General\
**Created:** [October 16, 2020, 8:19am UTC](https://forum.kintone.dev/t/topic/355 "2020-10-16T08:19:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\
**Post date:** [October 16, 2020, 8:19am UTC](https://forum.kintone.dev/t/topic/355/1 "2020-10-16T08:19:33Z")

</div>

(function() {  
“use strict”;  
kintone.events.on(‘app.record.detail.show’, function(event) {  
var subTotals = {};  
var subTotals2 = {};  
var subTotals10 = {};  
var tableRecords = event.record.order\_items.value;

// テーブル内の各レコードをカテゴリごとに集計する  
for (var i = 0; i \< tableRecords.length; i++) {  
var category = tableRecords[i].value[‘カテゴリ’].value;  
var price = tableRecords[i].value[‘単価’].value;  
if (category==‘1月’){  
if (!subTotals[category]) {  
subTotals[category] = ‘’ ;  
}  
subTotals[category] -= -1\*price ;  
}  
else  
if (category==‘2月’){  
if (!subTotals2[category]) {  
subTotals2[category] = ‘’ ;  
}  
subTotals2[category] -= -1\*price ;  
}  
// else ‘3月’,‘4月’,‘5月’,‘6月’,‘7月’,‘8月’,‘9月’,‘11月’,‘12月’  
else  
if (category==‘10月’){  
if (!subTotals10[category]) {  
subTotals10[category] = ‘’ ;  
}  
subTotals10[category] -= -1\*price ;  
}

// window.alert(subTotals[category]);  
// window.alert(subTotals2[category]);  
// window.alert(subTotals10[category]);  
}  
// 集計結果をスペースフィールドに表示する  
// window.alert(flag1);  
kintone.app.record.getFieldElement(‘m1\_total’).textContent += subTotals[category];  
kintone.app.record.getFieldElement(‘m2\_total’).textContent += subTotals2[category];  
kintone.app.record.getFieldElement(‘m10\_total’).textContent += subTotals10[category];  
});  
})();

&nbsp;

while my code only run with this case if (category==‘1月’);

another case is “undefined” ?&nbsp;

please help me/

thanks Developer Guys,

---

<div class="post-metadata">

**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\
**Post date:** [October 16, 2020, 10:51am UTC](https://forum.kintone.dev/t/topic/355/2 "2020-10-16T10:51:54Z")

</div>

It looks like your question should be posted in a Japanese forum.

Please could you seek for help in the following community: [https://developer.cybozu.io/hc/ja/community/topics/200034345](https://developer.cybozu.io/hc/ja/community/topics/200034345)