This content has been marked as final.
Show 3 replies

1. Re: Errors summarizing data based on dimension
Mahfooj Khan Jun 16, 2016 9:31 PM (in response to mike.shapiro.0)1 of 1 people found this helpfulTry this
Measure
SUM(IF [Strategy] = "AS IS" THEN [Sales Price] END)/
SUM(IF [Strategy] = "AS IS" THEN [EGV] END)
Let me know If this help.
Mahfooj

2. Re: Errors summarizing data based on dimension
mike.shapiro.0 Jun 17, 2016 10:47 AM (in response to Mahfooj Khan)So this is combining all sales prices then / by sum of all EGV, if strategy is 'AS IS'? I'm not sure this is what I'm after. Wouldn't developing the percentage of each cases first, then provide an average of those percentages be most appropriate?

3. Re: Errors summarizing data based on dimension
Mahfooj Khan Jun 17, 2016 11:01 AM (in response to mike.shapiro.0)Yeah you are right. Without strategy, measure will return ratio of Sales AND EVG of both "AS IS" and "AS REPAIRED".