Number Field to show correct ROI %

[Yerko_Begic]

I can't wrap my head around this... For demo purposes, I have created a pretty simple base that looks like so, and this all looks good

Then I created a simple interface; the only problem is the item highlighted, which is incorrect. 

I have tried all the options, and nothing is giving me the correct %. 

If I plot the same data in Excel, this is what I see:

Any idea how do I get the right ROI % (I need the result from the same table)?

[COXY12345 · Accepted solution]

Hi Yerko_Begic I replicated your formula and 1.07% is the correct value when adding up the ROI % then dividing by 4 to find the average.

What you have done on Excel is use the same formula to work out the ROI % as the 4 records above.

Example
What you did.
= ((B7 - A7) / B7) * 1
What it should be
=AVERAGE(D13:D16) 

[Yerko_Begic]

It makes sense... Thank you for the reassurance... My brain is fried, and was trying to figure out what am I doing wrong 

[Dan_Montoya]

@Yerko_Begic , I created a base to duplicate what you were trying to do with an interface that shows a few ways to represent the data.