GJZZH 发表于 2021-7-12 15:53:22

明细数据如何只计算一次

本帖最后由 BJTyyqx1128 于 2021-7-13 15:05 编辑

一个延期登记表,填写延期完成日期和延期天数后,业务公式将数据更新到计划表的要求完成日期,但存在不同的计划号,上级计划号相同时,上级计划号的要求完成日期累加了两次
例如图中的计划预计延期四天,更新到上级后累加延期了八天,如何不让它累加计算,求解决思路

GJZZH 发表于 2021-7-12 16:43:58

例如我的计划表是这样的


填写了延期登记表,将这两个计划的要求完成时间修改成延期完成时间,而它的上级的要求完成时间更新为原来的要求完成时间+延期天数
但因为两个计划的上级相同,在赋值时会加两次
业务公式图

zic 发表于 2021-7-12 16:15:06

不是很明白具体的意思,如果希望相同上级计划号不重复的话,可以把 延期登记表 的明细表做成数据接口,数据项为 上级计划号和延期天数 勾选重复数据只显示一次。再在被更新表去调用

zic 发表于 2021-7-12 17:34:44

本帖最后由 zic 于 2021-7-12 17:39 编辑

在延期登记表中添加数据接口

这样相同上级计划号 只会查询出来延长天数最多的一个数据
比如 下面这个表单 用上面接口测试的话 只会返回5天


在业务公式里调用接口


效果:
延期登记表:

延期登记表保存前,计划表:

保存后计划表:
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA70AAAC9CAYAAAB/NRoxAAAgAElEQVR4Ae2du64tSXKe99uMO0CjnW0MMHL1BJQotUhKW9SNL0C/jbHOvEEbBASM10Yf40jWADTbGl15hmpKLVItiexugJ5olBC1VtSKisrMuqy6ZEV9DRTyHhnx5x+ZGVVrn3758ccfGx4wgANwAA7AATgAB+AAHIADcAAOwIGIHHiJaBQ24axwAA7AATgAB+AAHIADcAAOwAE4IBwg6OVLN1/64QAcgANwAA7AATgAB+AAHIADYTlA0Au5w5KbN3u82YMDcAAOwAE4AAfgAByAA3CAoJegl6AXDsABOAAH4AAcgANwAA7AATgQlgMEvZA7LLl5q8dbPTgAB+AAHIADcAAOwAE4AAcIegl6CXrhAByAA3AADsABOAAH4AAcgANhOUDQC7nDkpu3erzVgwNwAA7AATgAB+AAHIADcICgl6CXoBcOwAE4AAfgAByAA3AADsABOBCWAwS9kDssuXmrx1s9OBCLAz/88EPDAwZwAA7AATgAB+DAXA5kg96UoIb/QAAEQAAEQAAEQAAEQAAEQAAEQOBECCSDXgl4v//++/Y5kS2oCgIgAAIgAAIgAAIgAAIgAAIgAAI9BAZBrwa88rNA/gMBEAABEAABEAABEAABEAABEACBMyOQDXrPbBS6gwAIgAAIgAAIgAAIgAAIgAAIgIAgkAx6gQYEQAAEQAAEQAAEQAAEQAAEQAAEIiBA0BthFbEBBEAABEAABEAABEAABEAABEAgiQBBbxIWKkEABEAABEAABEAABEAABEAABCIgMAh6IxiFDSAAAiAAAiAAAiAAAiAAAiAAAiAgCBD0wgMQAAEQAAEQAAEQAAEQAAEQAIGwCBD0hl1aDAMBEAABEAABEAABEAABEAABECDohQMgAAIgAAIgAAIgAAIgAAIgAAJhEXgq6P3w1ZcNDxjAATgAB+AAHIADcAAOwAE4AAfgQK0ceDro/ebb75oani+/+lCFHjVgUYsOrEkdvlELH86ix69/8dOm+c3v8IABHPjN7zTiD2fxXfQ8/szh3D9+Da7kB5H5Ft2233zzt83eD0FvJUF7xE0qssNGXC9sul1W2qD3P/yDpuEBAzhA0MsdYdZLD859gt497xKR+Rbdtr0DXpmPoJcDbdaBNmczi+ywc3Cg77kuAW3Q+x//YdPwgAEcIOjljjDrjsC5f67z7uz3k8h8i24bQe8Th0tkcpx1U2JNOPzOyN026P1Pv9s0PGAABwh6n7iXnHH/e1Znzn3O/Wc5NGd8ZL5Ft42g94nDJTI55mwANfVlTTj8auLjVF3aoPc//27T8IABHCDofeJeMnXPidSPc59zf08+R+ZbdNsIep84XCKTY88NZM25WBMOvzX5tJesNuj9L/+oaXjAAA4Q9D5xL9lrz6ppHs59zv09+RiZb9FtI+h94nCJTI49N5A152JNOPzW5NNestqg97/+46bhAQM4QND7xL1krz2rpnk49zn39+RjZL5Ft42g94nDJTI59txA1pyLNeHwW5NPe8lqg94/+6xpeMAADhD0PnEv2WvPqmkezn3O/T35GJlv0W0j6H3icIlMjj03kDXnYk04/Nbk016yCHoJ+Hnh8eCA+MNevsc85z8zOPfPv4Zn8sPIfItuG0EvQW+oy0Vkhz3ToYCu8y4hbdD78Z80DQ8YwAG+9D5xL7ni3su5P++8uSJH1rQ5Mt+i20bQ+8ThEpkca24Qe8piTTj89uTbWnO1Qe9vf69peMAADhD0PnEvWWtPOpMczn3O/T35Gplv0W0j6H3icKmdHD/5+c+SX3Fz9XbTmNLH9q8lX/uaHIVTbj1z9aKntmnqdff1Us49fizl/iWlDXr//Pebhmc2BsK5ubjpGE3njrf9rQybt33Iz+N2hJ83Cxdy+1ypTcaMtefkpsZaWZLPPSWZtbdFP/ftGqbWeGx9/Pix/rbdj7VlyeceKyNafgnfLG4ej1Kb9B1rt/Lm9LXjND/XNj+fL6vcXDqn/5y+qfnENoLe4EGvkkRTIUIu70li+/m2WstzHbZWO7bQK7WeqTqd27bZfKpd6lJ9SvUqh/S79stW899+v+EpYyAcm/qUsBQZ2m7zUjdFvo7V/lq2srwc7UNaXmPB5+xBr6x9ae+z7coT7a9lm+oeaeskr/U2TdWn6sbG2Pba89HPfb9+UraPro+ts2NsXvtKmuvv+9iyjvN1tpybz/Y5c34u3xQPTb3tWi+pPtJH8z71421Z+try3PxS23SenK6leh07lq5hG0Fv0KA3RQ6t86kQTeqmPmPEPLJ9rsMeqWsNcysXUrrk2rReUx3ry2P12k56D3q/+YOm4SliIBybgpHtJ/kpj8q1Y7XOprY9J1f6+35WBvky188c9Mq62z3NljWvqfYrlW1bLq9yJLV9bH0pv2RMSd7ebZHPfb82Y2XF3vazeW2X1NbbfK6PrS/lc7JKY87UNodvHgtb1rymikGp7Nt0jKZj7dovl65lm8jP6WLrbT6nk9bP6atjbCq2EfQGDXrtQvt8ijipOj9OylP7pcbuUTfHYffQp/Y5Suspbf4Re3SMpmqj72vL2oe0/7NmxaP9efNf/NOm4VkdA+GhxzVVp31KbdLHt9vylLzOQ5rn+1mDXll/9Wmbar1PpY+tk3zusX1tvtR/aj/VQfqf8Yl87uvaaKprquueW69cfzvO9/Gyte/cfrZ/Tr8z10/lWw4Hrfep4q+ptOeeHH4qM9c+Vj/VNtXRpppXnXNzWR21r02njMv1KdWLbQS9T2zyc8hRWogt2jyBbNnnt5j/KJk1r8lRmNj19jpIW6pOx/g2KesYTVN9qJt3eWyD3v/+z5qGZxIGys9U6jGUPlPqtE+qv7ZJ6tu9Dto3V6/tpHm+nzXo1f3Rr73uh1KvfWyq7ZpqP98nV6/jfH9btmO1v9ZpqvVnS6Oe+7Iuujaa17KukdZrWVPtp6mvl7Jts3nt6/vYcqq/1mlq5UTKz+GbYOEfxUJx8qm2a6rtUrZ5bbfpWLvtm8pPtU3m0bk0r2WVq/Va1lT7aerrtexT39+3j5XFNoLeoEGvLL4liM1bYmi9pFMfO762/FSHrU3vPfSZstZWD+0vdam81kk69bHyyT8CY4LefAD0bHDouSnypE7l2ry2+TG+rGO1v5atrFxe+5Lm1/zsQa/d24QHWta8TSWfKmu9tokMW2frVb72SZVT/bVOUzvuTPnI576ujaZ2XXydlP0j/W0/n7f9rWzN2/5Wlq8fa1N5EdI5fPM42bLmbSr5VFnrtS2Fo7ZpmuozVrfEttR8vk7K/hFdbD+b93pqm6a+fUpZbCPovWDQa0lj8540pTbft5byHIetRee99EitZ6pO9bFtqbytS43ROtJHcJvDog16/8db0/CsjoHwVHHVvKZSb/Opso7VNNVf6vRJ9fNjtA9pmvNXCXp1PxB+aF5SX9Y2Wz8lb2VJ/9Rj++g8Z0sjn/u6zprq2vhyaR1t32fydg6Rk3psH9U1WjqHbxZvj422aao4jZW1n091nKa+fUp5iW1+Pl+WeVN1vj7Xx/Yr9RmzT2wj6A0a9Aox9LGEKeXH2sYIVUP7HIetQd89dUhtFqk61UnbNJ1ar/1Ix4NdxagNer/9503DU8RAuDj1USylv89rnabaLmmqrtRu+/u8lPWxMsiXuX7VoFe54lPdJ6Q+lZc6bdPU9/P1pTE69ixp5HNf182mmrdr6PN27bS/ptpmyzZvZU2tL43R+aKkc/iWw6+El46RNPWkcNQx2ubLWj+WLrFN51JddQ6tl7LNa7utz7XbPjqu1Ff7pFKxjaA3aNDriWJJksunxkhf+6SIVFPdHIetSe89dNF111TmtPmUDrZd8z7VcVJferQf6TAYboPe//mHTcMzGQPhmsXLl7XN1s/NqwybehlS9o/09/2sDPJlrkcIepUTdr+TOinnUu2r7VrW1NbbfEqmH+P7l8bo2LOkkc99XTdNdU2knKqz7ZqX1Pf1db5dy5qqLC1rqvVWXqrN9jt7fg7fFAtJNa/2azmX+n5aTqUqQ9t8WevH0qW2Wbkyt5/flm1exvmylZVqH+vvx2tZbCPovUjQq4uuZNFU6zW19Tav7bWncxy2dlvW1k/W06+pL9s5tc2n2kfrtVxK5/QtyYna1ga9f/mHTcMzGQPhlMXLl7VN6yW1eWn3ZVun432qY3y9L9t+Nu/7UR7yPkLQa/cqWf9cWdskLT0y3rdbmZpXeb7sx2pZ5Wr/M6aRz31dT5tqXtdKyz7Ntdt6GaOP1ttUZWqdlnWMT6Wf9tEx0dI5fEth4etsWfOSlh6LqY6xdZLP1ft+trzENp1H9bXybFtKJ99ux6b6a7uO0/KUVGwj6A0e9Fpi2HyKTNru0ylkqqXPHIetRee99NB1tfOl6qTd10s5VWdllfJ+bKnvFdvaoPev/kXT8EzCQPjksbJ1ubyMsW1atnWSH3vs3H6stuXqtZ00z/erBb3CFbvv+bK22Xqb13ZJfb0v276an9JH+9aYRj73S2sjbbbdl2WtbLsv2zabt2vs633Z9tX8lD7a94zpHL6lsPB1tix5WxZ8fNliVmobG2vlaP5Z21SOt8OXU7p5W3xZZWs61q79NBXbCHqDB72y2CmyKQmUNJraeh3nU+1TYzrHYWvUf2+d/LrL/Kk6X6+cGNN3ar8xOdHb26D3f/3LpuEpYqB8yuGk7ZJKH021vy+n6nN9pvaV8VaGL6sc0jzfzxz06l6p666p7mG2LHlfr+0+1X651Pa3fewctl7yuTG+X+3lyOe+XT+7XrZe18fX+XKun9bb1M7l623Z5nNjbJ8I+bl8s7hoXnGwZcn7em33qfSz/XVcKp3aT8bOsc3KTelndbF9pd6Xta/Wa6r1uXRqPxkvthH0Bg56cySJXD/HYSPjgG3Dv5utGZM26P3uXzUNDxjAgebsQW/Ne01E3Tj3z3XenZ2DkfkW3TaCXoLe7s3S2Tci0T+yw0ZYH2xIX04Iegn4eeHx4ABBb3qfYP9M48K5n8YFvmyDS2S+RbeNoJegl6D3CQ5wqGxzqFwN1zbo/d//uml4wAAO8KWXM2nWvSTyRf1qZ+EZ7I3Mt+i2EfQ+cbhEJscZNp6UjqwJQWiKF7XXtUHv//k3TcMDBnCAoPeJe0nte90W+nHuc+5vwauczMh8i24bQe8Th0tkcuScvfZ61oTDr3aOpvRrg97/+0dNwwMGcICg94l7SWp/iV7Huc+5vyfHI/Mtum0EvU8cLpHJsecGsuZcrAmH35p82ktWG/T+9R81DQ8YwAGC3ifuJXvtWTXNw7nPub8nHyPzLbptBL1PHC6RybHnBrLmXKwJh9+afNpLlgS9f++P/5QHDODAH/8pQe8T95K99qya5uHc59zfk4+R+RbdNoLeJw6XyOTYcwNZcy7WhMNvTT7tJYugl4Cflx4PDog/7OV7zHP+M4Nz//xreCY/jMy36LYR9BL0hrpcRHbYMx0K6DrvEkLQ+wh4CP7AgqB33v5x9f2Wcx++7OkDkfkW3bZTBr2yKDxgAAfgQBQOyCWfBwzgwIMDUXwbOzin4AAcgAN1cOCUQW/z299ranjkgsJ/dSHwZ7/987oUQhsQGEHgiy/+pOEBAzgw5MCI69AMAi0CnPsQYU8EIvMtum0EvU8E0AS9e24z0+aK7LDTEKDX2RCwwc7ZdEdfEFgbAfxhbUTjy+Pcj7/GNVkYmW/RbSPoJeitaS95WpfIDvs0OAioEgEu+VUuC0odhAD+cBDwJ56Wc//Ei3dC1SPzLbptBL0EvSfccvIqR3bYvNW0nBkBLvlnXj10XxsB/GFtROPL49yPv8Y1WRiZb9FtI+gl6K1pL3lal8gO+zQ4CKgSAS75VS4LSh2EAP5wEPAnnpZz/8SLd0LVI/Mtum0EvQS9J9xy8ipHdti81bScGQEu+WdePXRfGwH8YW1E48vj3I+/xjVZGJlv0W0j6CXorWkveVqXyA77NDgIqBIBLvlVLgtKHYQA/nAQ8CeelnP/xIt3QtUj8y26bQS9BL0n3HLyKkd22LzVtJwZAS75Z149dF8bAfxhbUTjy+Pcj7/GNVkYmW/RbSPoJeitaS95WpfIDvs0OAioEgEu+VUuC0odhAD+cBDwJ56Wc//Ei3dC1SPzLbptBL0XCno/+eSTZu5ztv0ossOebS3QdxoCXPKn4USvayCAP1xjnde0knN/TTSRNYZAZL5Ft42g92JB75gz23YJkM/2X2SHPdtaoO80BLjkT8OJXtdAAH+4xjqvaSXn/ppoImsMgUV8+/iueX1913wcE35we3TbLhv0/uTnP2uaJwJeGfvrX/z0YHrOm35uEDu3/zxttuldctgP/+7fN7/85S+zj7SP//e+eXt5aV7a56153xtQapOO0u7H9ARQuCACXPIvuOhZk+0eIvuM3y9su22z9alxMuHU/cfKeszx8d3rfd/T/U/S1+Zd8RZXmjPdto0/WJtS+Nj2h803zKy9tk0XMW2Htj7S9Bzr4Wrlp2x8aPLIDXU/Th+r/zycS+f+w9Y9c9aW1FrYdmurrU+NExukjx2Ts8vKevQ/bn3Tus/Tx9ok+GT2n/dvib3T42RlPfBpe7XjRX56jkV8WxL0LhnjzZxZjm7b5YJeCXb1Iegte0O0oFcC3v/3d3+XfaS9/N/H5t3rS/Omka5sjF2h1NY07990A3Wba3lCWi+AwDaX/AsAF9HEj++aNxNFthfC7utAYY8pjpuz/xTm8HjLhaxw+S7teaW2TfyhiE/B5uK4ynAd0dUvX2kNen2XrvMsfQprIGHeyPm56KLeM3LlQtH2gq3FceM4PKwozPHodMvtsr4zdC/pk8LH70HteLlvle5aBXza8Y9g+haU92Ut4pvI7fZyvwj1lKPbdrmgVwNdvvSOOxlBr8fIvWHtbc6lNpXj+mg16aUR2OSSf2lEAxk/e4+5294bp3hM2X9cn6ScmzwJRF5NgK6z9FMnr9eYbtvFH3p2OT16bT2FmybZ5sa7Ibei65OUc+/5NK53BQpzPFR0ej0aupxf5zYAHVzex+V47Ppy3Pik7q5Pp2HTLLqom/GbZ3v2ODt6bU6TZJsb74bciq5PUs695yn5djd6YJfYLQGrs19fnHS8de1GThvkdh8zZB4XIDd9vvkv1b09sZWrHzxemhed/z7fO/PrGZmy9Qn7dVn6yZh7+q57+fMIyu9IrJZYX4poG0HvEz9x5ufNq/nZaoKsw3qhT3/pvW9U+qG3d4iX2jpF3Ebb1ZO5MgK7XPKvDPCJbW8vHe6ilNx/nI29cV3bhP1n0j4m98DyV95uyuJPMdP67OEPPXy8Lb78MKbpjevq03Z0zZLxMn1ZO+fqtb1Lx+dM69oJuGdG5CT06QerKm9ETgvB6+PS74MQP48vt9Pk5yid+6rhkWlvLbxtvmwU7Y3r6vM4dF28TF/Wjrl6be/S8TnTunYC7pkROQl90ny7iZO2R5Bpg9PhPD05fh5Tbu1IBL2PefpBb8/CVo4GpFaf+x7Q28uN7vefU3fTStkEu23Q++J+Zaiyego8X8j6UhDbCHoJerNeEvFL79/8zV83f/8P/u3gkXr9efMXX3zRYuLTwcWlvdDdNzizad4AlU1XNz+FeLgRawvpdRHY45J/XXTPbLnsF+aiM2mPEXvduA6CCfvPxDn6l81ugkSmNGe6bXt/cPhMtPk8uJY44JcovQbaa511nqDPpDXI65q9qKshh6bw7QF/fg1blvSC2Mcon2sDU/fvqvS5Wp6neJdrA1D7c+Zb8Dop6G2/CmfuhMJxDVRtXozLlbVeUwXCl7V+hTTvS4LD+W0j6CXozbpJ1KBXAtzUo0FvFhDZaOzfidiyzYsAX26FjmzE2YlpiIzA9pf8yOhFte12UbYXrcGekt1jzBeEHjzD/edxebz/9M7L9GWRl6gbyOnmHc7ZNWW+Am/rD1fBNceBB/q3XGF9EuvsRz/KBTn3lzA9Lj8G3nJ+Ll9ue+XnyF/U/UR7l+FbH/H8Gqb2lf7YRKnjyS0wvf3DU+bnxIMPD3cZ3bh0ubeftcG1efnoft4sEvr974Ghfq1VtWXOEwa90Wwj6CXoVZccpBGD3m+//bbJPaNBr7+k9TZOt5n32hRa10erSS+NwLaX/EtDe1Ljbxfl7qdunRVu/xjsMblxKsCN1+pe6voM5rj93VkxgCnJm9C2nT/k8BmzOTdOjXHjtbqXuj6b4Tqma0+p+68C7FetR3v/y9mjPp1z9nWdpurjxifwKf2rxXUGvTnbx2zNjVNQ3Xit7qWuTwLPfddXlXN6afX95+7T9xUdKPL8L+qkLT/PbaRrT+CjM6Rk9fjW+zLsvoZqkCvCZA4t27xvs2Xtp6kq5ctav0Ia3TaCXoLerJsQ9Hpobm8Tu8uobHZdodSmctxGq9Wkl0Zgu0v+pWE9qfGyR/S/KjwMKe0xpXEqYcr+U5oj/ZVXpafT0pzptm38oYRPyebSOLU4bYe23tLSHGvhOkXXvlapC33bQy7V9ldNZpgES+3fG5q6tJyyPn05I/i0c+Vx7l3Ue3odVSjZXrK1NE5tyeOgPQb/+FLvrnJevslXx+7KJcb2As6H9Sk+zuebyLutlQ/GLd/aL6GqVOs3GoTLOmn+/jX4ZEFvRNsIegl67U7Ry0cLeo/8//S2G+79ZzLyExy/ifaAp3ApBLa55F8KwjjGtpc4+/O8W17vVLfLnLabL3Qj4+btP7eL9/D/RZ6+AObAL81ZatvEH0bwCYHrqI39lcqvQXmd23F6eb9/obM/K+3OthF9vJzsGpTmuJtkg5C+lQeVRmzP2joyLr9mKTs39uMRXb1Ged1n8K0NKnX/k9Tsgb0Jhy8GpvPtpo9y+rH3Pibo883g/PrWvOnfvUp3g9Hr29v5vvTe/zShxSKIbZcNevV/XfRMyr/e/NgEasn1N6NatEIPEMgjsMklPz8dLSBQNQL4Q9XLU6VynPtVLktYpSLzLbptBL0X+9IrX2/nPGfbtSI77NnWAn2nIcAlfxpO9LoGAvjDNdZ5TSs599dEE1ljCETmW3TbCHovFPSOOXKE9sgOG2F9sGGIAJf8ISbUXBcB/OG6a7/Ucs79pcgxbgkCkfkW3TaCXoLeJT5f7ZjIDlst6Cj2FAJc8p+Cj8HBEMAfgi3oDuZw7u8AMlN0CETmW3TbCHoJejtHjpCJ7LAR1gcbhghwyR9iQs11EcAfrrv2Sy3n3F+KHOOWIBCZb9FtI+gl6F3i89WOieyw1YKOYk8hwCX/KfgYHAwB/CHYgu5gDuf+DiAzRYdAZL5Ft42gl6C3c+QImcgOG2F9sGGIAJf8ISbUXBcB/OG6a7/Ucs79pcgxbgkCkfkW3TaCXoLeJT5f7ZgjHfaLL76oFhcUqxcBLvn1rg2a7Y8A/rA/5mef8chz/+zYof98BCLzLbptBL0EvfM9vuIRkR22YthR7QkEuOQ/AR5DQyLAPh5yWTczCr5sBi2CEwhE5lt02wh6CXoTLn3eqiMdli+95+XNkZoT9B6JPnPXhID1Bc3XpB+61InAked+nYig1ZYIROZbdNsIegl6t9wbdpcd2WF3B5MJd0FAL/ekf9KAwXUxEGdLrf8uTsgkp0aAc//Uy3c65SPzLbptpwx6f/2Lnza1PEIQHjCAA3BgKQdSF33qrhv8XXXtxX9Sti/1K8axJ8MBOAAH4IDlwCmD3m++/a6p4fnyqw/N9983PBVhIOQ+ak3k581Hzc285/XD1EWfOoLeq3FA9rCUzext593b9lq7I8/9vWxknnr8IDLfottG0PtEAE3QW88mpAdCZIdVG0nr492zawJv463ps5y44niCXvxgCe/ZP+HNEt4sHROZb9FtI+gl6A31dfJIh+VLLwcvhygcWMoBxj24c+Q+zjo81uEsWMCX863ZWbiV0jMy36LbRtBL0EvQW9HPs1MbLHXxD/TIBw38jc/ftdcYf4AzczgFX+DLHL482zcy36LbRtBL0EvQu1LQy5deDt6lh2nkg2YpJoy7rj/hD9dd+yV+D1/gyxLeLB0TmW/RbSPoJegl6F0p6F26gTKOAzvyQQO/4fdcDuAPcGYOZ+ALfJnDl2f7RuZbdNsIegl6CXpXCnr50svBu/QwjXzQLMWEcdf1J/zhumu/xO/hC3xZwpulYyLzLbptBL0EvQS9KwW9SzdQxnFgRz5o4Df8nssB/AHOzOEMfIEvc/jybN/IfItuG0EvQS9B70pBL196OXiXHqaRD5qlmDDuuv6EP1x37Zf4PXyBL0t4s3RMZL5Ft42g90JB7yeffNLMfZZuCkeNi+ywR2HKvNtfKODt9hjD4/NgjD+cZ61q8Cv4Al/25GFkvkW3jaD3YkFvM+M/CZD33EjWmOtIh+VLLwfvUg4fydulOjMOvm/FAfwBbs3hFnyBL3P48mzfRXz7+l3z6afvmq9X+mXhszbkxke37ZJB709+/rNGn28IerNhMEHvHgfJ++azl5fmpX3eml/1NsRSm+gm7X6M1udkantq3B72MkfqsFl00PS4Aq4pXM9XZ31efNj7qW23bbY+NW6O31tZjzm+/vz1vk/p3iLpa/P51znupeV0a/Krt4c8dxlc3x+sLil8bPvD5tsea+21bWq3jE3Va7um6Tnm4yryUnNa+SkbVQ+bDuVsp89UrvR5NUWf9fliMVqSH1sL2265Y+tzazhcs86nemeClfWYYwqeQ3mpOa38nK4eu6Gc7fSpjG9Lgt4lY3oc8PiPlxf50hI9l4xZwbbLBb0S7NpA15dt21j+y68+nOpLqASxc/4j6B3fIOzhMP9L78fm809fms9+dZ9HLoGfvb9zqtTWNL/6TA6Z1EGzdNw8W63d5J/HbtFB8+QBwLo9v26rY/j1u+azzz9250p7IewCwoJvF8eV9guPQWEOzze5tGSDvbKcvl1eh6ZZ3R+K+BR0LY47AtfCnCO6eq7mzxC3HsV1nqlPjpVf94AAABiaSURBVC8p3Qt9Pe9W54vn+txyyp5T+vHM9e1sdBz6viDHYxuVbwcEed7np5QX+dKJbLtc0OsDWYLefBhM0DvcuKdsGtP7uLeevc2+1KZ6uT7t4eHqejJL47SNdPr6rYfVooPGXxYod8HiEWu4yZw9/53i23dO9sYpT934JF9cn6ScmzwJmj41AXrf/pIc15bQY3N/6Nnl9Om1KXa14Kr6OJ0TGH5fsqPrPy7Hr3MbLA+Cm3E5Xp+0nBLOtzavj/Buc750eCn+M9PeWjisem1ObrLNjU/q5vok5eTx7Puy9HPyUnMW5njIG5fj1zfNk3E5e/HNf6nu7YktJvqB4qV5Ub+5Y/W5+fWMfPxobW0/Zty/Uks/GXNPP+8+dpS+YjsOpdaqUGd9KaJtBL3uy68PiktlvvQ+51yPjXA9OdZht5Bfkjn7S+994+t+0mzLNi8blC+3m1Zi4/f9fDk3rrAJlmymbR3uHslb1nCdNdwCx94XUe/Lvmx8uDeuq0/sF13bHQMv05e1f64+1277yy9aPn1tPu3+rGMYPG/tDz18rG6ivy+rTd83TW9cV78jrjPmTOvquT6iewKLpUHItGDmpp/v2/lWQh9p25ov3fwd/h7Hcrm3Ft4GXzZz9MZ19SNrJv28TF9WWbl6be/S8TnTunpcRuQk9DkV31r9NSB1vyCRtl7Qa/a9+5969H71Z4LdNuh9cb8KVFndGnmsl5WzvhTEtksHvc985ZVgmKB3mVM9e4CUxmcdduWNoaSDBr9j6eBgat+mmjd8vZ93yWGhm6ninjhABofGxHE74lPC7qptNfD2qtjXa7f4rrnoTPJt2RvcuM63E/tF13bfUybOkQ1KVF5JTnvBe/yNYUrfbf3B4VPSVe1pUzeua9sR18lz5nTVs0PTsu6j6zxBnzYYSv4pjurwSMf65vTZli8P/ZbtFW4t4Jv7t0se+ObWd4h7nrdjHLKyxvrm9MnzTQLdzB1O1l0DVZsXH8qVtV5T9Tdf1voV0ui2XTbofTbgJeh9bFR2Ezk6n3fY7fXVIHcyBrJx2cDWlm1eN0Xbt93cEhv/0nErbJaT7Wauwc9wj+Qt67b93jAf49tFefhTORMsel/v9gTzBaHna8P94nHpu//0zsv0ZZGXqJslp/3S2/9XTP3lcjt/ODmu3XoO1/LBsYSN3TjP9YKcxDo/5pghR+eeIy/VN1V3l70dX7ydc8uJtfB2+HJrU2Kc4pj4qfEs/1M5iXkHcrRvYs4HF0q6erxi8q2Hm36c8Puc4H3CoDeabZcMetcIeAl6/WZWR7newy+FjzsAeodQqU1luT7dYTnlYmz6dAebyiV9HOj7YHEu3u6Dyd5rUM984tfmC2/nn87fe/uFrElunK6XG9/J1XaVYfaGwRy3vzvrBeNz5Qy+9A5lbuMPOXwcLgObc+MUNzd+Lh73/j7wL/MxN+eYrqqzpjk5wzVZpo/OI6nM5X+tZNttfti3hM82fLH6LMnn1sJhDt/al8Cl9R1yz2GY9bkd+Nbbz9yXXg1yRT9ZZy3bvG+zZe2nqdrpy1q/QtrzpYC2XS7oXSvgJehdcghsP6bnsCtsAMPNNm/D7C+937u/+ZANZuK/3nzTK7Xxl2Sq7qlx2kY6Z83X6nskb9eyATlr+I74ZirgFdkl3y6NU72m+H1pjvRX3vS6l+TcdO0CZ7nAuWBofX8o4TOua/e3dskzZU9cS2tZslHH+TSje7sm5uWHsVuCk+4f5Onqh3LkC1EPt94F+v6P9tyDgLG+qV8XWN6tzxeP09xyaS3gW/fvmCh/Tsy39kuo3tt6e5lw4BF0t/1OFvRGtO2SQa8EvvaRAHbJw9/0zj0Itu9f3+E3ZvPtcEz/74fybe3FI/sPwSwdN6Yr7faitWb+fLyFC2uufyerDQzMv/Z59/FH8JDx7ZFx5f3Cr2VmjnvQ3QWremHNpjk5Mp9tGwb5q/vDCD59fUywNzLuCFyzc47o2nHsvl5ZOSPr3I7Ty3vvf0Vz423HjzYAsFw2uOo4lVPsewsSO7kJvq3Ol8QcHr9ieXQtLP8NLiPj8mvmfdj7mJljZH29Xdk5R3SdLGdEn/r5Ztby07fmM/2bXuGQwejTz97O96XX7tNBbLtc0LskuM2NIehNbbTH1h15+M3/0nssVv5QonzcehzJW9b9uHUH+zT2+EMaF/iSxgW+pHGBL9vgEplv0W0j6F34lVcC4TMGvfL/3p3znG3TjOywZ1sL9J1+4MLb6VjBq/hY4Q/x13hNP4Yv8GVNPo3Jisy36LYR9F4o6B1z5AjtRzosX3o5eJf60JG8Xaoz4+D7VhzAH+DWHG7BF/gyhy/P9o3Mt+i2EfQS9A7+9ynPbghHjo/ssEfiytzbXirg7bb4wt9z4Ys/nGu9jvYv+AJf9uRgZL5Ft42gl6CXoPfZf7TiPp4vvRy8Sw/eyAfNUkwYd11/wh+uu/ZL/B6+wJclvFk6JjLfottG0EvQS9C7UtC7dANlHAd25IMGfsPvuRzAH+DMHM7AF/gyhy/P9o3Mt+i2EfQS9BL0rhT08qWXg3fpYRr5oFmKCeOu60/4w3XXfonfwxf4soQ3S8dE5lt02wh6CXoJelcKepduoIzjwI580MBv+D2XA/gDnJnDGfgCX+bw5dm+kfkW3TaCXoJegt6Vgl6+9HLwLj1MIx80SzFh3HX9CX+47tov8Xv4Al+W8GbpmMh8i24bQS9BL0HvSkHv0g2UcRzYkQ8a+A2/53IAf4AzczgDX+DLHL482zcy36LbRtBL0EvQu1LQy5deDt6lh2nkg2YpJoy7rj/hD9dd+yV+D1/gyxLeLB0TmW/RbTtl0PvlVx+aWh4hCA8YwAE4AAfgAByAA3AADsABOAAH6uTA4UHvDz/80Mz578NXXzbfPPF1ds2xEnjzX10IyEZz1H/ypZf/QGAJAkfydom+jAGBLRHAH7ZEN55s+BJvTWu2KDLfottG0PtEAE3QW9+2FNlh60MbjdZCAN6uhSRyIiCAP0RYxf1sgC/7Yc1MTfvrzqg4RPYlsY2gl6A3lO8e6bB86Q1FpV2NOZK3uxrKZCAwAQH8YQJIdOkQgC8dFGR2QCAy36LbRtBL0LvDFrHfFJEddj8UmWlvBODt3ogzX80I4A81r059usGX+tYkskaR+RbdNoJegt5Qe9ORDsuX3lBU2tWYI3m7q6FMBgITEMAfJoBElw4B+NJBQWYHBCLzLbptBL0EvTtsEftNEdlh90ORmfZGAN7ujTjz1YwA/lDz6tSnG3ypb00iaxSZb9FtI+gl6A21Nx3psHzpDUWlXY05kre7GspkIDABAfxhAkh06RCALx0UZHZAIDLfottG0EvQu8MWsd8UkR12PxSZaW8E4O3eiDNfzQjgDzWvTn26wZf61iSyRpH5Ft02gl6C3lB705EOy5feUFTa1ZgjeburoUwGAhMQwB8mgESXDgH40kFBZgcEIvMtum0EvRcKej/55JNm7rPD/rHqFJEddlWgEFYVAvC2quVAmYMRwB8OXoCTTQ9fTrZgJ1c3Mt+i20bQe7Ggd85eIwHy2f470mH50ns2ttSj75G8rQcFNAGBGwL4A0yYgwB8mYMWfZ9FYBHfPr5rXl/fNR+fnXzj8dFtu2TQ+5Of/6zR5xuC3qwLEfRmoVmx4X3z9vLSvLTPW/O+J7nUJh2l3Y/R+pRMK0/aU2N7ClDYCYFFB81OujHNngiM+ahtt/5r63O+LX3smJxdVtaj/8d3r/d9SvcWSV+bd9lbXFpON+v7t4c8dxlc3x+sLil8bPvD5tsea+21bWqJjE3Va7um6Tnm4yryUnNa+SkbVQ+bDuWsp4+Zp13rqRhl+u3KF6P7ouzYWth2a6+tz63hcM3SKlpZjznWW18rP6er12yo+3r6mLlq5NuSoHfJGAPDkuyivXeJnkvGLDHIjBHbLhf0SrBrA11ftm1j+S+/+mDgrD87N4id278GBBY57EqKz//S+7F59/rSvGmkKxt1Vyi1Nc37N72IPQ6zmxmFcR/fNW/mhtoeNu6yuRIUiJmJwJG8nakq3bdEoOijy307v194YwpzDLq+a16zwV5Zztjes7o/hMG1sPcXbfSLV5Dju8rlNLvOE+S048eDohJHd+eLx2BuubgWBd8ojpuAdadnYY6uzz2zdH1HdPXTlNa313epPiqkVr6JXie4by3ae09k2+WCXh/IEvTqTjFMCXqHmKxb49569jb7Uptq4fq01a6uJ1PH3dNSm+tKcVsEFh0026qE9BoQ6Pnos77txiftc3168/cHyCX21bxEc639r589OW6O/sC2tLk/lPTptTnlkm3j9gy+zCbl3OYq46r6TJizMIdKGej1aOhyXp82eBlc3nP6SL38GmDYPl3OcGyn3D2zOV/8hHPLvbVw9vTanOBkmxvvhtyKrk9Szr1n0Y9VuJOn1TYtzPHoNi7nbHzzX6p7e2KLiX6geGle1G/uWL0zv56R7x2tT7S/+rv/gkb6yZh7+q772FH6hc0D7SU560sRbSPodV9+fVBcKvOld4lLbTvGOuy2Mw2lz/7Se9/49ENvY8s2L1P5cjt94gDx/XzZqD329tx0JbsxAkfydmPTEP8EAj0f9b7sy2ae3riuPrFfdG33jJfpy9o/V59rt/3lFy2vr81r92cdw+B5a3/o4WN1E/19WW1qm14fF9eufkdcZ8zZs7Eb5zMjuiewmB6s2q+Nw3kmy6mALx61ueXeWnhMfdkI743r6odYdk2a8TJ9OddP6wfp+JxpXb2gETkJPSfzpKmAb63+GpBafe77Si/oNfte+3Ns96s/E+y2Qe9Lot3Du0I5u/cGse2yQS9/0zvuHXzpHcco1UOD37F0eLmSA8G84ev9pMy0dZMmDpDBoZEaJwKk3myinUwyRyCQPWiOUIY5K0HA+ejTvp3YL7ylE+eQi2jvi8YcOe0Fz/5ZhrOzaZpt/cHNN9Hm/J65I64dzmNzOhu7cT5TljO6zp24oZz+2GF7N7SXSfQ7nC89BRcUxCZz1sI392+XPCDtc+ZRP8wNedIfO2wfypCaRL+n+CaBbuYOJ+tug17Nixq2zZa1XlM1wpe1foU0v/fGsO2yQa9+weXnzXkvIejNY7NKi2xcNrC1ZZuXyXy5VSCxYft+vtyNG7m0rmIgQqYikD9opkqgXywExLedj3pf9uUWgMS4DpjhftF+ndEvrvplIbcnqZzEvLPkyKXSXvjk6umC6O38IYGPt8eXa8JV1yB1We+1Oe50bT4z5ETXI4lD1+oyXs7tK9ftH2g0P+/Ul7pu9KPo5bTkOJAvD82W5eBbH7fE+mqHE/Ott/8px/0+J/bpvmfzYn+urPWaWqxUltatlPq9N5ptBL38vDnrKgS9WWhWanAHgGxs3YWz1KbTuz5ttavryZQO0m7eOqso0kMR8AfNocow+cEI5Hz0Wd9245NWuj6D/WMYoCbF+KDMyhl8SRnK3MYfIuCqaLt10urZ+3tOznBNuimSmbycW/exdhWa6HcYX1SnpanYkjprnY3WN9qpcuNUDzdeq3up6zOYY631HdO1p1T6y+q9i3/x5Uf2y86+fmNxnn7XhJy5fOv1d19DbWAqa6BlmxeFcmWt11SV92WtXyHt7b0Bbbtc0Ou/7PqyfgGekvI3vSt42Moieg67suz1xd3ehnf/YLNsMF2h1KaaJDbs3t+13N+SdzLnHlA6D+nWCJyLt1ujcWX5JR8t7QmlcYpnar/QNk1Lc+R+caJjbVqSc9O1+3m0XOD068hdxPr+UMJnXNduC7Umdvk9cdVJU3OWbNRxPk3JKa+zBCf+S33yZ6K9qYbzTJdzs2tfvvSUX1AorQV86/4dE0W23QPsnzxowy04r5lv7ZdQ3SB6e5lwQP++V+Ja8+8B+KA1V9Z6TRUWX9b6FVK790a07XJBrwSz+ve8zwS8IoegdwUPW1mEddiVRW8k7nY4zv3/9LYXBv1Zov8Z5P1t/0Bm+9bO/tTsltf9eiMDETsBgfPxdoJRdJmPwKiPZvaLkXHl/cKrmZnj/kKtCz78sEE5J0c62rbh17DV/WEEn74+5vI9Mu4IXLNzjujqlycrZ2Sd23H6xap9r9o/U9L8kPU2uOq4yXJ25osHa255dC2sPQaXkXH5NUspmJljZH29pOycI7pOljOiT/18Mzi/vjVv+je9AoDB6PXt7Xxfeu0+HcS2Swa9U77iTulD0Ou3tePLq1+WjjcJDS6AALy9wCJj4mQE8IfJUNFx83/4DIhBoI9A5P0pum0Evd9+10wJcFN9zhj0yt/pznn6rl5/KbLD1o8+Gi5FAN4uRY5xERHAHyKu6nY2wZftsEXyEIHIfItuG0HvhYLeoevGq4nssPFWC4sUAXirSJCCwNb/yyIQjoYA+2e0Fa3bnsh8i24bQS9Bb927y0ztIjvsTCjofiIE4O2JFgtVN0cAf9gc4lATwJdQy1m9MZH5Ft02gl6C3uo3mDkKRnbYOTjQ91wIwNtzrRfabosA/rAtvtGkw5doK1q3PZH5Ft02gl6C3rp3l5naRXbYmVDQ/UQIwNsTLRaqbo4A/rA5xKEmgC+hlrN6YyLzLbptBL0EvdVvMHMUjOywc3Cg77kQgLfnWi+03RYB/GFbfKNJhy/RVrRueyLzLbptBL0EvXXvLjO1i+ywM6Gg+4kQgLcnWixU3RwB/GFziENNAF9CLWf1xkTmW3TbCHoJeqvfYOYoGNlh5+BA33MhAG/PtV5ouy0C+MO2+EaTDl+irWjd9kTmW3TbCHoJeuveXWZqF9lhZ0JB9xMhAG9PtFioujkC+MPmEIeaAL6EWs7qjYnMt+i2EfQS9Fa/wcxRMLLDzsGBvudCAN6ea73QdlsE8Idt8Y0mHb5EW9G67YnMt+i2nTLo/fKrD00tjxCEBwzgAByAA3AADsABOAAH4AAcgAN1cuCUQe8RSjPn3zZgAAZwAA7AATgAB+AAHIADcAAOwIFxDrz8+OOPjT4//PDDrN8xfPjqS4Kvb8ZBhohgBAfgAByAA3AADsABOAAH4AAcOIYDBL0Erby4gANwAA7AATgAB+AAHIADcAAOhOUAQS/kDktu3qQd8yYN3MEdDsABOAAH4AAcgANwoCYOEPQS9BL0wgE4AAfgAByAA3AADsABOAAHwnKAoBdyhyV3TW+X0IW3nXAADsABOAAH4AAcgANw4BgOEPQS9BL0wgE4AAfgAByAA3AADsABOAAHwnKAoBdyhyU3b9KOeZMG7uAOB+AAHIADcAAOwAE4UBMHCHoJegl64QAcgANwAA7AATgAB+AAHIADYTlA0Au5w5K7prdL6MLbTjgAB+AAHIADcAAOwAE4cAwHCHoJegl64QAcgANwAA7AATgAB+AAHIADYTlA0Au5w5KbN2nHvEkDd3CHA3AADsABOAAH4AAcqIkDBL0EvQS9cAAOwAE4AAfgAByAA3AADsCBsBwg6IXcYcld09sldOFtJxyAA3AADsABOAAH4AAcOIYDBL0EvQS9cAAOwAE4AAfgAByAA3AADsCBsBwg6IXcYcnNm7Rj3qSBO7jDATgAB+AAHIADcAAO1MQBgl6CXoJeOAAH4AAcgANwAA7AATgAB+BAWA4Q9ELusOSu6e0SuvC2Ew7AATgAB+AAHIADcAAOHMMBgl6CXoJeOAAH4AAcgANwAA7AATgAB+BAWA4Q9ELusOTmTdoxb9LAHdzhAByAA3AADsABOAAHauIAQS9BL0EvHIADcAAOwAE4AAfgAByAA3AgLAcIeiF3WHLX9HYJXXjbCQfgAByAA3AADsABOAAHjuEAQS9BL0EvHIADcAAOwAE4AAfgAByAA3AgLAcIeiF3WHLzJu2YN2ngDu5wAA7AATgAB+AAHIADNXGAoJegl6AXDsABOAAH4AAcgANwAA7AATgQlgMEvZA7LLlreruELrzthANwAA7AATgAB+AAHIADx3CAoJegl6AXDsABOAAH4AAcgANwAA7AATgQlgMEvZA7LLl5k3bMmzRwB3c4AAfgAByAA3AADsCBmjhA0EvQS9ALB+AAHIADcAAOwAE4AAfgABwIywGCXsgdltw1vV1CF952wgE4AAfgAByAA3AADsCBYzhA0EvQS9ALB+AAHIADcAAOwAE4AAfgABwIywGCXsgdlty8STvmTRq4gzscgANwAA7AATgAB+BATRwg6CXoJeiFA3AADsABOAAH4AAcgANwAA6E5QBBL+QOS+6a3i6hC2874QAcgANwAA7AATgAB+DAMRwg6CXoJeiFA3AADsABOAAH4AAcgANwAA6E5QBBL+QOS27epB3zJg3cwR0OwAE4AAfgAByAA3CgJg4Q9BL0EvTCATgAB+AAHIADcAAOwAE4AAfCcoCgF3KHJXdNb5fQhbedcAAOwAE4AAfgAByAA3DgGA78f69XMnAguZpLAAAAAElFTkSuQmCC


Prex 发表于 2021-7-13 14:40:09

重复累加的原因:
801-3,801-4,是同一阶层的,你是数据源又选的是明细,明细中有多少条记录,业务公式就执行几次,所以你801-2的日期会加8天(如果你同一阶层3条记录,就会加12天),801-5这一阶层就1条记录,所以计算801-1的天数应该是正确的。
页: [1]
查看完整版本: 明细数据如何只计算一次