用友财务软件互动问答平台

 找回密码
 立即注册
查看: 293|回复: 3

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

[复制链接]
发表于 2018-6-14 21:15:52 | 显示全部楼层 |阅读模式
用友畅捷通T3财务软件的用友T3财务报表模块中碰到如下 问题,T3累计公式,为什么显示为空白?,详细问题描述如下:

                               
登录/注册后可看大图

公式可见,但是显示不出来的。
回复

使用道具 举报

发表于 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 | 显示全部楼层
您好!是取数取不出来?这个公式是怎么设置的?这个科目上有数没有?中间的行号怎么也是断的?
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|用友十万个为什么 ( 赣ICP备13006939号 )

GMT+8, 2025-8-26 13:53 , Processed in 0.069057 second(s), 19 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表