This content has been marked as final.
Show 2 replies

1. Re: Cant mix aggregate and nonaggregate comparisons or results
Justin Wagner Feb 3, 2016 9:02 AM (in response to Mahadev Somashekhar)2 of 2 people found this helpfulYou are summing Profit Ratio which means you would also have to sum up everything else in the calculation or take out the SUM() in the Profit Ratio calculation.

2. Re: Cant mix aggregate and nonaggregate comparisons or results
Mahadev Somashekhar Feb 3, 2016 9:19 AM (in response to Justin Wagner)1 of 1 people found this helpfulHi Justin,
Thank you for the suggestion, adding sum to rest of the calculations worked.
Much appreciated.