如何將FileMaker的合計欄位，以中文大寫金額顯示？

<p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; text-indent: -14pt; line-height: 20pt; background: white; margin: 0cm 0cm 0.0001pt 14pt;"> ◎如何將 FileMaker 的合計欄位，以中文大寫金額顯示？

<p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin: 0cm 0cm 0.0001pt; background: white;"> 這是有位網友為解決廟務捐款明細的個人小計能同時以中文金額顯示，因為直接以計算欄位來指定合計欄位，會產生全部的總計金額，而不是個人小計的金額。

<p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin: 0cm 0cm 0.0001pt; background: white;"> 解決辦法：

<p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin: 0cm 0cm 0.0001pt; background: white;"> 增加一個計算欄位 以 GetSummary( 統計欄位 , 分組統計欄位 ) 來巢狀套用函數即可 以下是我完成的巢狀函數使用： TranCMY ( GetSummary ( 實收額合計 ; 貨品 ) )

<p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin: 0cm 0cm 0.0001pt; background: white;"> TranCMY (...) ：是我的轉成中文大寫金額函數

<p style="color: rgb(139, 86, 9); font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin: 0cm 0cm 0.0001pt; background: white;"> 函數寫法參考： http://blog.xuite.net/hwarnder/program/501625122

南區農漁會電腦小組園地