问题描述
限时送ChatGPT账号..我正在尝试绘制一个包含两列的表格,即该街道的平均价格和该地区计算的平均价格.(每个区域有多条街道)
I'm trying to draw a table with two columns, the avg price on that street and the calculated avg price in that area. (Every area has multiple streets)
在行上我有街道.在列上我有价格和平方米价格.myArea 是一个计算字段:
On rows I have streets. On the columns I have price and sqmPrice. myArea is a calculated field:
{ INCLUDE [myArea] : AVG([sqmPrice]) }
出于某种原因,这些总是相同的,如果街道在同一区域,我希望 area-column 总是显示相同的值.添加 myArea 后,为清楚起见:
For some reason these are always the same, I would expect the area-column to always show the same value if the streets were in the same area. With myArea added, for clarity:
推荐答案
在这种情况下,您需要使用 'FIXED' 并将您的计算字段修改为:
In this case you will need to used 'FIXED' and amend your calculated field to:
{ FIXED [myArea] : AVG([sqmPrice]) }
这篇关于为什么我计算的面积价格总是和价格一样?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
更多推荐
[db:关键词]
发布评论