T+专属云15.0 报表公式设置需求

发布时间：2024-6-25　

问题描述：

在一个UFO报表中两个单元格，一个格子取科目的所有年度累计借方数，另个格式取科目当年的累计借方数，这怎么设置公式？

问题回复：

1、取当前年度累计借方，可以用年关键字：LFS("1001","","年","月","借")，也可以直接写当前年：LFS("1001","","2020","月","借")

2、取所有年度的累计借方发生，需要写指定年度的合计相加，如LFS("1001","","2018","月","借")+LFS("1001","","2019","月","借")+LFS("1001","","2020","月","借")