我的位置：首页 › 一站式数据分析平台-亿信ABI › 亿信ABI-问题求助 › 表间取数范围内满足条件的数据和 ...

[ABI 5.2] 表间取数范围内满足条件的数据和

复制链接 | 收藏本帖

495

: lingzed 初学数据Lv2

发表于2024-1-18 11:48

悬赏50

已解决

楼主

本帖最后由 lingzed 于 2024-1-18 12:10 编辑

要求：A表的表元 = B表中字段1为"项目名称"且字段2为"其中：研发费用"的范围内字段3的值之和
表元的表达式如何写

且如果B表增加了一个项目成本和其中：研发费用的数据，A表的表元取得和也要跟着变

$HHH-CELLOBJ$[[{"type":"","cellname":"B10","value":"

,"stl":{"bcl":"transparent","stl":"","valign":2,"ishorz":true,"halign":2,"wrap":false},"wrap":false,"indent":"2.1.2.1","dec":"2","len":"50","editor":"input

","stl":{"bkcl":"transparent","stl":"","valign":2,"ishorz":true,"halign":2,"wrap":false},"wrap":false,"indent":"2.1.2.1","dec":"2","len":"50","editor":"input"}]“”“

","stl":{"bkcl":"transparent","stl":"","valign":2,"ishorz":true,"halign":2,"wrap":false},"wrap":false,"indent":"2.1.2.1","dec":"2","len":"50","editor":"input"}]]