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)?
Best answer by COXY12345
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)
+5Hi 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)
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)
It makes sense... Thank you for the reassurance... My brain is fried, and was trying to figure out what am I doing wrong
+17@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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
