为什么我计算的面积价格总是和价格一样? [英] Why is my calculated area price always the same as the price?

问题描述

我正在尝试绘制一个包含两列的表格，即该街道的平均价格和该地区计算的平均价格.(每个区域有多条街道)

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屋！