[数据处理]
自由表中如何计算某个项目的当年实收保费占整个实收保.....
yhdata_ruby
显示全部楼层
发表于 2022-10-12 15:04:52
不是固定的,根据你自己的单元格位置进行替换,我这里的0表示第1行,rsize-1表示最后一行,如果你这一列有表头,你可以把0替换为1表示第二行,rsize-1可以不用替换 |
|
|
|
|
yhdata_cGxQ0JdB
显示全部楼层
发表于 2022-10-12 15:32:29
rowTotal(int column, int rstart,int rend),
现在是 int column是表示要计算的总和的那列是第几列吗? 比如现在要计算的显示的是第三列,前面有项目列,实收保费不含税的列,那现在是要计算的是实收保费不含税该列的列合计,那是第2列?
按: left(1)/colTotal(3,1,rsize-1)
报错,显示格间计算有循环依赖?
按: left(1)/colTotal(2,1,rsize-1) 也不对。
请问只有格间计算这一种方式吗?还有其他方式不? |
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 15:39:17
本帖最后由 yhdata_ruby 于 2022-10-12 15:42 编辑
是的,你这里需要合计的是第二列,column就应该填1,因为row,column是从0开始计算,自由表左上角的第一个为原点。
你这里红框中应该是要填一个表头,就应该把格间计算放在下一行: left(1)/rowTotal(1,1,rsize-1) 你还可以使用计算列,获得需要的数据再进行绑定,但是格间计算也比较方便的
|
|
|
|
|
yhdata_cGxQ0JdB
显示全部楼层
发表于 2022-10-12 16:19:47
left(1)/rowTotal(1,1,rsize-1),还是不行,不报错,但是并没有计算呢,都显示的是0呢?
不知道哪里不对?
有没有办法直接计算列或者新建表达式, 直接计算出占比这列,然后拖拽数据即可?
需要如何计算呢?
知道在sql中可以按下面方式计算:但是在报表中不知道如果计算?是否有sql表达式或者其他方式?
select distinct t2.item name,
(sum_premium_tni_real_y/total_sum_premium_tni_real_y)
from (select item_name, sum(sum_premium_tni_real_y) over() as total_sum_premium_tni_real_y
from ccic_xbmis.dm_all_xty)t1
join (select item_name, sum(sum_premium_tni_real_y) sum_premium_tni_real_y
from ccic_xbmis.dm_all_xty
group by item_name) t2
on t1.item_name = t2.item_name |
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 16:36:46
left(1)/rowTotal(1,2,rsize-1)设置这个试试 |
|
|
|
|
yhdata_cGxQ0JdB
显示全部楼层
发表于 2022-10-12 16:40:06
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 16:47:43
本帖最后由 yhdata_ruby 于 2022-10-12 16:49 编辑
那就先合计,再用以前的值去除以合计值吧,先把合计值计算出来,再去算 |
|
|
|
|
yhdata_cGxQ0JdB
显示全部楼层
发表于 2022-10-12 16:50:50
啥意思? 先合计是增加一列sum(当年实收保费), 然后再用格间计算?
那合计那列不需要在表中显示呢?
可否详细说明下? |
|
|
|
|
yhdata_ruby
显示全部楼层
发表于 2022-10-12 16:56:30
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAfoAAAEUCAYAAADDW/S7AAAgAElEQVR4nO3dX2xb6Z3e8cf2aGxZkT1IRGGssUYqysU6VGa9CLAYRHF2ptVhN+gCMYJuQdFFgQKkLiljsZcyGZSU0LsGI17shai7xhSLFlkvsMEWpNrRrqtgsujuaGfJKhsWkEZjTVZUBpE1tqzIlnpBUuJ/kRTlQx99P8AA4uH5845s+Dnv733fc84dHBwcPN7+Uo8+W1Mtb13vlyTt7D7XG1e6au4LAIAV7e7u1r3vxYsXT7El9TtvdgMAAMDpIegBALAwgh4AAAsj6AEAsDCCHgAACyPoAQCwMIIeAAALI+gBALAwgh4AAAsj6AEAsLDXzG4AAABnUmpG7sVhRb1DR9sycfl9EaXLdrbLE56SYSs5Ppg49jIEPQAAJsjYhuVZCcp9z6vpSaeOMtyQf25MjsPPSUVG71c+if3o2Ex8QuML7xd/Xr1D0AMAYAabbUjGZEAro0E9SDnldUjKrFTozdeQjmh8NFK4oeRzkKAHAMA8Q/LOxbI/5krxdk+4oDdfg2NM0bmxss2piEvRgbBCzl5J0jmzXlP7g+SP9LMvfqHl7drXreRG93V962s3FHC4T9wOAADq1ZrX1G4occ+n2VzXfSQQk1fZkB8JxLI9+xKpiEuh3HC83RNW6K0HdY3PSyYF/Q+SP1L00wXtHbxo+hyvnbugfz/wLwh7AMBL09r30WcDf+VO5XBvVmmP3pTS/c+++McThbwkPT94oZ/+arlFLQIAwFyZ+ITGZ2uN0JdO0lONmfc+uWezP5kS9Mvbn7XPeTJx+X0rcpf+8hpSWIapsATi2Ot/qPcaOaaRc6Rm5L4/WDKjs9Z5jn4X+RmbRUs/AACnwua8K8+CTwvvHfXG81IRl0IarpxT9tJZ+8WYjFfi+Duq3PiIM6PIaFDzBduik/k/mGTRd0WMQFFwph5ElDYCCuX/hKquoSy8dvFfgMzHHyptf1/juXNk/0IEWh7Q+d9NURvqXMeZV238CQDQK+OOodngA6WcBZ3P1IxCCUP+uSr/ppfNvC/2ygX9lY7Lerz39NTOb3NOKeos2VixV5zRcb330lDL9pAL90hqMf+Hl++VB95XxfJMrmqwUHaVDS0tpDVyZyrXtqQWE3Z5wseHfOHkjiNG8cdEUO78PkZA0Yp/0Sq1t7ydiXs+rRzbKgA4wxxj8hsuhe7lMicTlz83Sa/qv7FW6tG73v6O/uM7/07/5uF/UnJr9fgDaigNudBo9sPL7HGmIkGtesLyKtcrN+4oZFuvEOa1TvJAs2lD/nybU4uaV1ryuTRbsFvR3V6uquDwxhT1FuyUK90XMUorA9kHNwwW3eAkDn9/xxmpay8AOFsy8QlN665Czl45vGF57vkO/90+Npes0qN3vf0d/fCb2fWC37j69omD/jDkWjJG34TUjEIrXk17eyUl9WB2MNezX2/gJBtK3E/oqBee/Vz0l+LYMfrSYYaSHv3KujIaOjo2tah5DcpfdDJ69ADQuIxW0tJ80KV5SSOB3JBoZkkLBeO3q482JEdvxTNIenV69P2Xe7T2dLPid4Uh/8d/O6PYp3/9Mpt2KjKPVqR0ouiO7Sgoq/eQ7e8VnCP+gYqmE5T27mvKB7wh/1xM3uwJi3r0NucdjcwGy+4Uyx/mQI8eABqWHQHWSG55XSrikjuY/WokEFPIIWX/rc7NoD8M9OJ1+JLav0efD/JKIf7yQj4XfGWl6lrSmi0pkWfH7e8ce+ThXIBMXJGPb5aUZeoYo8/ENT0reQJeLQSz4Zx5tCK7526dlYns05gKK/eyORWaO2afUpWezJSakTu40tjqAwA4a2xD8k7Gsp2s0YjSFf/tz/87nM2A8dFIdkL0ZKy0/lpVWwR9Xj7Q82F+6iFfMMM9NKqjnm3dqk3GS6r6vVWhDSUeSLe9NUoy1WRWJM9dGbalw/C3OacUavhENVYIlCn+S1h5Mt+R8pugnGPKTABwpticCs2VzgIv1SujgXAv1BZBnw/wH35z7DDY85+l0wj5fNnDkD/sVdSMMXpJqYhPswlJidxtgRFQ9HadBzvGsmWdTH5DeSmnUHFZp/QGpY61/xUm6pVN5gMAtJ22CHqpetifTrm+4M4oE2/xueuV1GJC5b3bzLrqHaMvVuVur64H5lQagqik0r1kIxWBBh8mBAA4sbYJeikb9l99vVv+b4xKkkLJuVdu4l0qMqH128eP0dce/25kHX0rNNejL3T8ssQa71MGAJyatgp6SfrT9E9k776W/fkXPzG5NfXLj1ePBGLy2iqP0WdWK9TVC5+EZ/dq+u4pN7Sik/Tos/LLQ2qzy9NQuwAAJ9V2QS9Jf/J3x0fOy5R5tCJpsGTjulaV1nwuIEcClcarS8fNC55Yl390rN2r6blYQenejKGEk/To85WJbAlfgZi8joKfbdkbmQEefQsApjAl6G90X2/JC2ludF9v+tiiZ9obgYpl8sKJbSOBqQpj3Mc9KKbGLMmyZWnFY91V16WnfXIvmDBrPbNS+fn7Bc+6HwnEdNu2UbLDTY2HvZr2ueSWmHEPAC+ZKUH/ra/dUPrLz/X8hO+jv9XTfBex4jPtD9WxjKFszflJ1bFmvZl2OMYUnWyiOZVerlNyQ5S9WZI84Vi2GlB0TP7BPb2yKb90JLcONNLHG/EA4CU5d3BwcPB4+0s9+myt5o5vXe+XJO3sPtcbV7pOfOFgKqqf/urnWt6ufd1KbnRf160ehya+7jpxOwAAqNfu7m7d+168ePEUW1I/08boAw63WZcGAODMOG92AwAAwOlpy1n3AAC0u2fPnmn78Zb29vYkSR0dHeq+clWXLl0yuWXFCHoAABq0s7OjL35V/MbV3/zmN/rVZkZf/VqPOjs79etf/9qk1hWjdA8AQIO+3H7c1HdmIOgBAGjQ8+fPm/rODAQ9AAAN2t/fb+o7MxD0AABYGEEPAICFEfQAAFgYQQ8AgIUR9AAAWBhBDwCAhRH0AABYGEEPAICFEfQAAFiYaS+1WV9/pN1nz/TkyZOGj+3q6tKlS5261td3Ci0DAMA6TAn69fVHOifpt37rt3ThwoWGj3/x4oXW1tb0+fo6YQ8AQA2mlO53nz1Tf39/UyEvSRcuXFB/f7+ePdtpccsAALAWU3r0T548aTrk8y5cuNBU2b+6DSXu+bRyJyavQ1JqRu6g5J8bk6PC3qmIS6FEc1caCeSuAQDAKTNtjL7dZOIfaFZeTecD2HFbHrtP0fhthZy9Zfs7vDFFvRVPJL/vQ70XnpJhO9UmAwBwLGbdS1ImrulZyXPXqaNs7pVxx1B69gMlMg2c6uMPlba/r5uEPACgDdCjV1IRX0TyhMt74I4xTXsmNO6bUV/FEn623D+bLt2e1vhopPxSRkBR71CrGg4AwLHOeNAnFRkNat4IKFqhPC9JNueU/KsuhUZX5KlSjq9nzD0Tn9D4aguaDABAA85w6b4g5I/pZTu8MU17pFmfS/74xrFnTkXq2w8AgNN2RoN+Q4l7Qa16wnWX0m3OKUXnAhqY9ckdSZ5y+wAAaI0zWrrvlTEZk6GkIqM+zddzSK7n752LqdJkewAA2tEZDfq8wuBOKjJ6X4Nl4/DZCXcLA/VOo9/Q+oo0MFx5zB8AgJfpjJbuK8isa1WD6jvxsriMVtJ2DbK8DgDQBgj6nNSDiNLGcMWn4DUiE7+veaU165toaP09AACn4YyX7nNSMwol7PKEK03My2glLQ3cqVSKz471H+2ae/BOOCYjMyO3z6VZGdnH6DqnFD2t9gMAUMUZ79FvKHHPJXew+hp5pRY1rzpK8akZuX0RDQRy53GMKToX07RnRaFRFzP1AQCmMKVH39XVpRcvXpzoxTYvXrxQV1dX08dn4hMan03L7gkrOtlbtr2QvdJT80r3t3s1PRdT6W4255SizuyEPveovfoNBQAAp+DcwcHBwePtL/Xos7WaO751vV+StLP7XG9caT5gJenz9XVJB02/qjb/PnqdO6dr18x4H33Bo28beaxtaqZ29QAA0NZ2d3clqa7M3Nlpj1epmxL0Ujbsnz3baepVs11f+YouXbpkUsgDAM6qVzHoTZuMd62PkAYA4LSd8cl4AABYG0EPAICFEfQAAFgYQQ8AgIUR9AAAWBhBDwCAhRH0AABYGEEPAICFEfQAAFgYQQ8AgIUR9AAAWFhTQX9w0OpmAACA09BU0J871+pmAACA03CC0v05HRzQuwcAoJ019ZraXz9u/B3yAAC86jovmvZ296Y11eI3rnS1uh0AALS93d1ds5vQMGbdAwBgYQQ9AAAWRtADAGBhBD0AABZG0AMAYGEEPQAAFkbQAwBgYQQ9AAAWRtADAGBhBD0AABZG0AMAYGEEPQAAFkbQAwBgYQQ9AAAWRtADAGBhBD0AABZG0AMAYGEEfcskFRl1KZIq2ZyJyz86oUTGlEYBAM44iwV9UpHRGZVmbV4mPiF3JPlSW5R6EFHa/r5u2l7qZStLzchd4/cDALCe18xuQGsNadgIKnRvUNOTThVlayau6VnJEx6qeGQmPqHx2XT9lzICinorn6vwmtGEJEU0Phop+3okEJPX0WQb6rk+AODMs1jQSw5vQCOjQU3Hbyrk7M1tTSrii0iesIwqPWubc0pRZxMXzMTl90V0GM9Bl+aVDfHhxex2uydc0JZ8oA9q2FHhfHUEeCY+ofHVJtoKADhzLBL0G0rc86moMzzrk3u2ZLeCbaXh2zSbU6E5p7LDBkEp30vPxOVPGPLPDWtx9AMlfndKhi0f8pInPKZKOd+MRqsRodHE4c8t+z0AANqSRYI+q7QUrtSM3PfLy/ipiEvRVl88tZjtyec/PohoIBCTQ5Ij/L78Ppey9xh2ecJTVSsLzai7GpGakTso+edad5MBAGhvpgT97v/9S/2Xv/mNfue739PvVetMbvwf/fgvP9Hrv3dHf/j11+s673yubF6q0vi43ZP/KdsTr3Tc8Y5CO7WYOGqDEVDUGzsK08zKUWlfg+o7rYl5qRn5H92mhw4AOGRK0F+8/rZsf/Mz/f2f/zft/MEf6vf7O4u+f/75T/Xf/+Ln+vJ1m969Xl/IS8326IfknYvJW/r9QEFJOxOX37cid9WecFK5nNdIIKbbjyYUSU3p9qN8Sd0uTziWvSGIuLKlc7u3fMKgJCWCcidKN1ZglG/K2AY1EPTJL8rxAIAsc0r33Q597/sX9Bc//ql+8T9+rKff/p6++/WvSJKe/r//qT/7X59q5/U3Nfz97+rr3aa0sCGZ+H3N2+2yp7P9dptzSsMRl8YThvxzU0U3Bw5vTFFvNvDHRz8sL+MXTsarcqNSbTKezeaUNyz5fYQ9ACDLvDH67t/WH/7R64r/eEGf/u8/14+3nTLe+Fh/9leP9JvOt/X+9/+l/vnlxk7ZXOm+1IbWV6SB4XpDMqkHs5InfEcrvuDh1nygV1Pp+8xqWvaBgkh3DGskHdSDlLOoUmFzTlWfY2BzKhRYkZuePQBAZk/Gu/zP5Pz+6/qrP4/rF3//F/qvkvQVu/7ge7d0vcGQl1o1GS+jlQaW0yuzrlXjjrw2qfh2osJKgCJGyaS4SjcYQ7rtsWv8fly3K5X5q3GMKRqQ3PeXlHE2cBwAwHLMn3V/+S39/h99Vxd+/Jda1m/rX3//W7rWcKt6ZUzG6t7b4Y0pVO3L1KLmZch/3LT03Pr5gUBMIa8kVX7iXsXla7kx/5KNWknbNViSyjbnXXkWfCXPBaiDY0zRyfp3BwBYk/lBL0mvvalv/9v/oG83c2xqRu5g7dlrlUr3WeW96sT9hGQE6lx+Vh7MTUstat7+vqbLztcrYzKglVFK8QCAxrVH0J+EY0zRubHK31Up3VeTivg0mzbknzz+0bKZjz9UWoNytyToszcY9vfCVdo5JO9cWIl7PrkXqszWr0NqMTvbn1I+AJwdr37Qt0R+LX1pDz/H5pTbcBU9UU6SRgJTx/b805We0CepaH1c6kHuBqNWbz07PHEzPpGtUBz3qNyKlQ67PGHG7AHgLCHoc2Pt8oQVrVEWP24WfTXHj9Fne/MjgVhdwwX5p+Bl4hNyj6arP8K2VqUDAHBmnDs4ODh4vP2lHn22VnPHt673S5J2dp/rjStdL6NtAAC0ld3dXUmqKzN3dnZeRpOOZbH30QMAgEIEPQAAFkbQAwBgYQQ9AAAWRtADAGBhBD0AABZG0AMAYGEEPQAAFkbQAwBgYQQ9AAAWRtADAGBhBD0AABZG0AMAYGEEPQAAFkbQAwBgYQQ9AAAWRtADAGBhBD0AABZG0AMAYGEEPQAAFnYY9OfPV8/8Wt8BAID2dZjgr732WtWdan0HAADa12HQf6X7StWdan0HAADa12FXvbOzU1/rsWn78Zb29vYkSR0dHeq+clWXLl0yrYHtZn39kZ7t7Ojp06dmNwUAzrTLl7vU2dmpa319ZjelrRXV5C9dukSo17C+/kjP9/b05ptvMm8BAEy2v7+vzc1Nfb6+TtjXQFo14NnOjnp6egh5AGgD58+fV09Pj57uUGGthcRqwNOnTwl5AGgj58+f1w5DqTWRWgAAWBhBDwCAhRH0AABYGEEPAICFEfQAAFgYQQ8AgIUR9AAAWNirE/SZuPyjE0pkau+WirjkvhfXMbsBAHAmmPRauqQio0HN19rF7tX0pFO2Bs/s8AY0MhrUdPymQs7eE7QRAIBXn0lBPyTvXExeSdKGEvd8WrkTk9dRvFcmPiH36h1FvUNlZ8jEJzQ+m65+iVmf3LPlm+2esHk3AFvL+uiTXfXduqn+su2b2ivauVsDJfttLX+kTzbze3Wo5513dePqKbcZAPBKM/9F86kHmpVX047jdy1jBCreBFS9VMSlaBOXObG1JT1c3c596K6yU3mwF8qG/CUN3HpX/fnPnyxprcYxAACYPkafWkxI6YjGR11y5/+rY4zd5pwqCvlUxCV/fKNon0x8Qu5I8vCzwxszoTe/pqXVbXUP3NKtgSoh/3i3pDdffo6VzT11DxyF+tUbN9TTsa315a3WNhcAYCnm9ugzcUUThvxzY3IcbprQ+GqfbFKNsM+W+8sr95XK9UG5E4Wfi693+vp181Yuntdq7NZxUVeqfbf2hbbVrYGirvtVdV2SNncfS6J+DwClUhGXQgooOrwodzAfBHZ5wlMybNLhfLGi6nB226qZw7wtZmrQpx5EJE+4IHQ3tLSQ1sid48rxvTImYzIKzxVxKTpQ/AeTvWmoPMbfTraePJP2tvXJw4e5LcVl/K0nz6SOq2U3AlcudkhbT7Qloh4AKkoE5VZA0bkxSblc8E1I4SkZtiF5w16t+u4rcTsb/qlILvgtEvKSmUGfmlFoxatpb8EvM/VAs2lD/nq726mZgrs0qWaPvslZ/C/D1Rvv6lbB57Wlh1p9uCQx/g4AJ2P3arqgs2dz3pVnwaeFjzdkOHslm1NuI6LQg6SM4UWFEob8c+3dOWyUecvrgivyhMeUibg0XpDV9qIefj3qKMWnZuS+31RDTdF/8x09+egTrS9vqZ9p9QDQvMG+kg5er/oGpfRqRlK2o5lflu1OSCOB2Esc2n05zJmMl1rUqueuDFt2glx0Lia/Icnu1fhJyyWpGcs9MOdq1yVpb1ePS7Y/3t2TLnVRtgeAE7Fp0G52G06POUHvGCsbSw8l7PLcPXlp/XAWf8WwTypSx9P1zPdY2QzPRfiVi+rQMz0pmmC/pSfPpO6vUtwHgPoltZiQRoaPyvOZ+AeaHQwoGjA0H5xRysTWnQbzl9dFXBqfVcEsyCOlS+jKOMYULSzbp2YUShjyeOzl+006Zcusa1WD6muzgfq1paWiCflrS6vaVre+erSWTn3de9pcXlY+67eWl7WpHg2S8wBQXSJYtPQ6FQlqXoaG88GRmslm0O0hyXFbHntCoYJl2VZg4qz7/GNw7RVDvrLKIX34lDy7V9NzTik+UfnwzIrS9sE2nJC3rdWHD7Wa/9jRo3du3SgqyfffvCUtPTyamd/Ro3fevUHZHgBqMQJyr/rkHj3ccDSvKxOXP5iQ3RPOZVCvjLteLfiC8g9YZ3nduYODg4PH21/WfcDO7nO9caXrxBdORVzZWfe1ZsKXzqo/XOtY/Kz88sfaVn+W/kig/FG79fqHT/5edruFB3IA4BWUTqf1jXd+p2z74Tr6Fi6x3t3dlSQ9+qzWg1Gkt673a2dnp2XXPQnTgv5VRNADQPsh6GszfYweAACcHoIeAAALM//tdQAAnAKHN2bOG0vbDD16AAAsjKAHAMDCCHoAACyMoG9AZ2en9vf3zW4GACBnf39fnZ2dZjejrRH0Dbh8uUuZzU3CHgDawP7+vjKbm7rcdTaf7VIvZt034Fpfnz5fX9cvf/lPevr0idnNAYAz7XJXlzo7O3XtWp/ZTWlrBH2DrvXxFwoA8OqgdA8AgIUR9AAAWBhBDwCAhRH0AABYGEEPAICFEfQAAFgYQQ8AgIUR9AAAWBhBDwCAhRH0AABYGEEPAICFEfQAAFgYQQ8AgIXx9roGra8/0rOdHT19+tTspgDAmXb5cu41tbxVtCaCvgHr64/0fG9Pb775ps6fpxgCAGba39/X5uamPl9fJ+xrIK0a8GxnRz09PYQ8ALSB8+fPq6enR093qLDWQmI14OnTp4Q8ALSR8+fPa4eh1JpILQAALIygBwDAwgh6AAAsjKAHAMDCCHoAACyMoAcAwMIIegAALKwtgj4Tn5A/vtGSc6UiLrlHJ5TItOR0AAC80sx/BG5qRuOzkifcKympyGhQ8zV2HwnE5LXF5fdFlK66V1qzPpdmK35nlyc8JcN2smYDAPAqMDfoM3H5gysFwTsk71xM3mMPdCo05zz15rXGmpYermr78HOHet55Vzeulu62pIerR3t1D9zSzf6X1EQAgGWZF/SpGbmLQr45mfiExmer9+0PGQFFvUPNX6hZW090sSC0t5Y/0ieffKTlwrBfW9LD1WfqeedWdtvakh6ufqTlKxVuCAAAaIBJQZ9UJCj556bkkLI9+w+k8Umnmsr8Y0I8E5/Q+GqTTT2pqzeKwvrqjT51P1zV7mNJVyVpS8vr2+roeedov/6bGvjioVZX1kS3HgBwEiYF/ZC8c/lgTirii0iecHMhL0mJoNyJY/Yxmj35Kdv6XFt7Hbp6rbjrfuVih7T1RFvK3Q8AABqSirgUUkDR4UW5g/mQKJynlZsXVtRZzG5b9YQVcvaa0/AWM30yXiqS+yU7pcQ9l46vwhdPprM5pxR9VYbrJa0trWq7o0fv5Dvqj3e1p0vqKknzq12XpM1dHXb8AQCNSwTlVkDRuTFJuQqvb0IKT8mwDckb9mrVd1+J29lcOcoka4S8ZHLQpyIuhRLSSCB7J2VMxso73pm4/L4P9V7pWH5qpuAOrX4jgZi8jqab3JSt5Y/0yeaeJKmj5x3dukl0A8BLYfdqumBo1+a8K8+CTwsfb8hw9ko2p9xGRKEHSRnDiwolDPnnTJjPdYpMCvoNJe75NCu77DUWyR3PkH9uTPXldvaaKye4WrOu3nhXt3I/by1/pIcP95hVDwAvw2BfybBwr/oGpfRqRlK21+7wBjQymh0CHgnE6syUV4c5QZ96oFl5NT3ZpwejwRacsNb6+/ZaN3/1xrsaWHqo1S/WpP5+6cpFdWhLT0oG47eePJM6ruqKaS0FgLPCpkG7dKJ+ZxszJ+gdY4pOSlKypactL8snFRm939JrtNzVLl3SZsEs/KzHu3vquHqN8XkAaKmkFguGjCUpE/9As4MBRe8syh2c0XDdleJXg+mT8VppPuiq0Ku3y2NCW/LWlpakmzfVf7RBq9tS90B+S78Ge9b1yeqS1vpz+60taXW7WwOM5QPAySSC8g8czaBPRYKalyF/PskPn846JNls8th9CkWGzXnuyimxVNCbMdHuOFcuPtMnDx/qaBl/x9GDcXKu3nhX7yx/VLBftwZuFdwcAACaYwTkXvXJPXq44WhuVyYufzAhuyecG97tlXHXqwVf8c3Bq679gz6zorQG5a45xp59dG653KS/w3GXgru4l6RwIl4r9gMANMbhjSla6dnqtgqPU6+07RXXlkGfX3Z3yAiUj5c4xhSdO+5MvZWX7AEAcEaYHPSVe+JV774AAEBD2uJ99AAA4HS0ZekeAICTcnhjiprdiDZAjx4AAAsj6AEAsDCCHgAACyPoG9DZ2an9/X2zmwEAyNnf31dnZ6fZzWhrBH0DLl/uUmZzk7AHgDawv7+vzOamLnd1md2Utsas+wZc6+vT5+vr+uUv/0lPnz4xuzkAcKZd7upSZ2enrl3rM7spbY2gb9C1Pv5CAQBeHZTuAQCwMIIeAAALI+gBALAwgh4AAAsj6AEAsDCCHgAACyPoAQCwMIIeAAALI+gBALAwgh4AAAsj6AEAsDCCHgAACyPoAQCwMIIeAAALM+01tT9I/kg/++IXWt5ea/jYG93X9a2v3VDA4T6FlgEAYB2mBP0Pkj9S9NMF7R28aOr45e3PlP7yc0ki7AEAqMGU0v3PvvjHpkM+7/nBC/30V8stahEAANZkStAvb3/WVucpk4nLPzqhRKaRg5KKFB1T+rkVzZqQ+15cLTwlAMDiTBujN10mLr8vonTBJrsnrJBTSnwQUdoIKGSrdvCGEvd8mk1X+Mrn0mytz5JkBBQdXpQ7mKjZxGx7eo/5HwEAoLpXLuivdFzW472nLTqbIf/cmBy54F55q1epiCsb4Omg3EU5bJcnPCXDJkm9MiZjMorOlVRk9L4GD/cp/SylIhNav53/PKTo3Fj2i0xcft+K3HNjchSdc0OJey6t3InJW/wFAAB1eaWW17ne/o5+9q/+s4auDrT2xKkHmpVXw48mFErY5QnHFJ3L/xeWxy7JuHMY2JKy4VxURh+Sd26qYJ/85w0l7mVL+I7b72vhg/LSe+pBRPLcFlkOAGi1V6ZH73r7O/rhN7M94G9cfVvJrdUWnXlDifsJjbznVXRWssVcuzwAAARGSURBVNvTmq1Ubs/38O1eTU86dZT5SUVGg5o/7jIF55yO3ywoySe1mJDS8sldcNH8MAIAACfRNkHff7lHa083K35XGPJ//Lczin361627cK43P+10yuY8JllTM3Lfr/RFYVm/wmFFJftimfh9zRsBRb1DuS1HwwjSRv3/HwAAVNAWQZ8P8kohfqohL0mO2/LId9jLTkVcCtWaI2f3VvmiSs/eCMivtFYykmxJRUYXNXw4Fp/Ug1nJEx462j+zpIW0ITd1fABAC7RF0OflAz0f5qce8pKkXhl3DM3eX1LG6ZTDG1O0WpaX9ujTEY2PSpJdHklHk/uSitxb1+1ciT8VyR+/qHn7oG7nP0aCWvWE5S3o6aceZGf8k/MAgFZoi6DPB/gPvzl2GOz5z9JphnyOY1gj6ftayvRpxXfMeHu+R29zKjTnVH52fS22AbskKbWYkP29cHZ8PzWj0IpX096MIqO+gmvai3v4AACcQFsEvVQ97E895IsMyTsXUzbKS8vshUrL9PkefUKh0aO6//xoRCOBmG5LWn0UlxKG3HPZSXipxRV57o7JJuWumT3nqudu1bF+AAAa1VbL62Kf/rVC/zB3+DmUnDvlkE8oNOqSezSoeeN96QOX/PGkEvdciqSG5A1IoUjycO9UJP+kuyF55wIakSH/XEAjGlSfTcqW7o+W5vlzC+1tbw0qPRvRasESOoe3cHLehhL3gpq3ezXOA3IAAC3UNj36vD9N/0T27mvZn3/xk1O+Wn5MXcr20u16765NWsh97bgtz/0HSsmm9Xs+LQwakm9GfRV7+VJpj16SRoYl2QZlz4d4akbuxeGCWfa56kDZsj0p/2AeAACa1XZBL0l/8ndlq9hPXXaZ2x1FbdJRVPfKmByTlNRi2q737o7JGJ6RP76h0O+ua7VgYl1Wpcl4SUVGI0rLyD4o59GK7AO5o1Iz2cfgVgz5Kgb76tsPAACZFPQ3uq+35IU0N7qvt6A1krShpQXJczfby775nl2zQVfxpDy7V9M2SbYxhRxSJv6h0oN3ZEstat4YllfSYoUzZ+L3pUBM/kWXovHbGj/8JqlIMHHs8+xLl/uNBJioBwConylB/62v3VD6y8/1/ASvqn3t3AXd6mnVIrReGZNTh59szilFaz47Z0NLC4PyT9qUuJedVCclVWkyXra3LtkcAQ2M+jQuuzzhXkm98s4dX5avudwPAIBjnDs4ODh4vP1l3Qfs7D7XG1e6TnzhYCqqn/7q51reXmv42Bvd13Wrx6GJr7tO3A4AAOq1u7srSXr0We3seut6v3Z2dl5Gk45l2hh9wOE269IAAJwZbbW8DgAAtBZBDwCAhRH0AABYGEEPAICFEfQAAFgYQQ8AgIUR9AAAWBhBDwCAhRH0AABYGEEPAICFEfQAAFhYU0F/cNDqZgAAgNPQVNCfO9fqZgAAgNNwgtL9OR0c0LsHAKCd/X/n91p/fts9JQAAAABJRU5ErkJggg==)
“先合计是增加一列sum(当年实收保费), 然后再用格间计算”对的,是这样理解,如果不想展示合计那列可以进行隐藏,在设置中选择隐藏列
|
|
|
|
|
yhdata_cGxQ0JdB
显示全部楼层
发表于 2022-10-12 17:09:21
先合计是增加一列sum(当年实收保费), 这里的合计是在自由表里面怎么合计新增列呢?
新建表达式不行,新建聚合表达式不能拖到自由表里面??? |
|
|
|
|