
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 04, 2024 02:14 PM - edited ‎Apr 04, 2024 02:17 PM
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)?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 04, 2024 05:10 PM
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)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 04, 2024 05:10 PM
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)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 04, 2024 05:37 PM
It makes sense... Thank you for the reassurance... My brain is fried, and was trying to figure out what am I doing wrong

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 04, 2024 05:49 PM
@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.
