1 of 1 people found this helpful
SUM(IF [Strategy] = "AS IS" THEN [Sales Price] END)/
SUM(IF [Strategy] = "AS IS" THEN [EGV] END)
Let me know If this help.
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?
Yeah you are right. Without strategy, measure will return ratio of Sales AND EVG of both "AS IS" and "AS REPAIRED".