# Number Field to show correct ROI %

Solved
348 3
cancel
Showing results for
Did you mean:
6 - Interface Innovator

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)?

1 Solution

Accepted Solutions
4 - Data Explorer

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

3 Replies 3
4 - Data Explorer

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

6 - Interface Innovator

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

Community Manager

@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.