你好,创建一个视图包含主表,与提取出来子表的收入与支出。视图实现:
- SELECT
- "业务编号",
- "客户经理",
- "应收金额",
- (SELECT IFNull(SUM("收支金额"), 0) from "收支" where "收支"."费用类型" = "收入" and "主表".ID ="收支"."主表ID") AS "收入",
- (SELECT IFNull(SUM("收支金额"), 0) from "收支" where "收支"."费用类型" = "支出" and "主表".ID ="收支"."主表ID") AS "支出"
- from "主表"
复制代码 之后,创建公式字段转换“收入”与“支出”两个字段为整数,支持筛选。
|