Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Number Field to show correct ROI %

Solved
Jump to Solution
747 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Yerko_Begic
6 - Interface Innovator
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

Yerko_Begic_0-1712264015124.png

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

Yerko_Begic_1-1712264190574.png

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

Yerko_Begic_2-1712264267382.png

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

Yerko_Begic_3-1712264330155.png

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

 

 

 

 

1 Solution

Accepted Solutions
COXY12345
4 - Data Explorer
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

See Solution in Thread

3 Replies 3
COXY12345
4 - Data Explorer
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

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
Community Manager
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.Screenshot 2024-04-04 at 5.45.15 PM.png

Screenshot 2024-04-04 at 5.48.21 PM.pngScreenshot 2024-04-04 at 5.48.15 PM.png