问题现象: |
用户环境:u861预算管理,已经打好8月30号的预算管理的补丁.现用户在定义以下公式保存时出错,估计应该是公式过长引起的。请帮忙解决为感. 此公式主要目的是将业务预算转化成财务预算,多个业务预算的项目几个部门的预算要取到财务预算中来 用户定义的公式: GETBG(预算版本号,"2020102020104","11211001",周期类型,预算周期,,,,,,,账套号,账套年度)-GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ",预算机构,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",102,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",103,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",104,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",109,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",111,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",113,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",115,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",116,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",117,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",118,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",119,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",120,,,,,账套号,账套年度)+GETBG(预算版本号,"20202020102","11211001",周期类型,预算周期,"Organ",121,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011601","11211001",周期类型,预算周期,"Organ",预算机构,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011602","11211001",周期类型,预算周期,"Organ",预算机构,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",102,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",103,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",104,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",109,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",111,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",115,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",116,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",117,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",118,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",119,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",120,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202011603","11211001",周期类型,预算周期,"Organ",121,,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","102",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","103",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","104",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","109",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","111",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","113",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","115",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","116",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","117",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","118",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","119",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","121",,,,,账套号,账套年度)+GETBG(预算版本号,"202010202010405","11211001",周期类型,预算周期,"Organ","120",,,,,账套号,账套年度) |