there are 2000 properties in 10 different countries. Each property has a purchase price.
there are 5 appraisers. Each of them reassess some of the 20 properties.
This leads us to two tables.
1: property, country, purchase price, date of sale announcement, status of sale
2: appraiser, property, estimated price
Table one shows property, country, purchase price overruled by estimated price of selected appraiser if exists (called "current price")
IF(
ISNULL(ONLY([estimated price by appraiser]))
,ONLY($(setexpression) [purchase price])
,ONLY([estimated price by appraiser])
)
where $(setexpression) restricts to specific timeframe when sales have been announced first as well as to specific status of sale
wanted: table two should show the sum of current prices per country (formula above aggregated by country) restricted to properties that fit to $(setexpression) in general
