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
