嘉兴新禾_王兵 发表于 2018-6-14 21:15:52

T3累计公式，为什么显示为空白？公式可见，但是显示不出来的。

在用友畅捷通T3财务软件的用友T3财务报表模块中碰到如下 问题，T3累计公式，为什么显示为空白？，详细问题描述如下：
https://sto.chanapp.chanjet.com/4a47ecad-3fcd-422b-879b-b2df91606e00/attatchment/2018/04/24/1524552137Svv9.png
公式可见，但是显示不出来的。

用友软件张彩用 发表于 2018-6-14 22:41:43

那这样说的话，跟期末的设置一模一样，那么从科目余额表看，期初到底是有数还是没有

用友软件工程师 发表于 2018-6-14 23:04:12


期末余额和期初余额分别公式如下；
QM(\"101\",月,\"借\",\"001\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"002\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"003\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"004\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"005\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"006\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"007\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"008\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"009\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"010\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"011\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"012\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"013\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"014\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"015\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"016\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"017\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"001\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"002\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"003\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"004\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"005\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"006\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"007\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"008\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"009\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"010\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"011\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"012\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"013\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"014\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"015\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"016\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"017\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"001\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"002\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"003\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"004\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"005\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"006\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"007\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"008\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"009\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"010\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"011\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"012\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"013\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"014\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"015\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"016\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"017\",,\"\",,,,,)+QM(\"352\",月,\"借\",\"016\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"019\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"019\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"020\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"020\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"021\",,,,,,,)+QM(\"103\",月,\"借\",\"021\",,,,,,,)+QM(\"103\",月,\"借\",\"021\",,,,,,,)+QM(\"201\",月,\"借\",\"021\",,,,,,,)\n\n\n\n\n\nQC(\"101\",月,\"借\",\"001\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"002\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"003\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"004\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"005\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"006\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"007\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"008\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"009\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"010\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"011\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"012\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"013\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"014\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"015\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"016\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"017\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"001\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"002\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"003\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"004\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"005\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"006\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"007\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"008\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"009\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"010\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"011\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"012\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"013\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"014\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"015\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"016\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"017\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"001\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"002\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"003\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"004\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"005\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"006\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"007\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"008\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"009\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"010\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"011\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"012\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"013\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"014\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"015\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"016\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"017\",,\"\",,,,,)+QC(\"352\",月,\"借\",\"016\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"019\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"019\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"020\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"020\",,\"\",,,,,)

社区专家 发表于 2018-6-15 00:37:03

您好！是取数取不出来？这个公式是怎么设置的？这个科目上有数没有？中间的行号怎么也是断的？
页: [1]
查看完整版本: T3累计公式，为什么显示为空白？公式可见，但是显示不出来的。