ROI Calculated Field Formula

Below is the correct calculation for ROI. If you leave out the “sum” aggregation you will get the wrong answer.

 

((sum(sales)-(sum(cost))/(sum(cost))