Help

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

Help with finance/investment tracking formula

Topic Labels: Formulas
Solved
Jump to Solution
827 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Torus_Global
6 - Interface Innovator
6 - Interface Innovator

Hi everyone, struggling to pin down a formula…

My goal is to track investments over time (i.e. date of deposit, how much was deposited, what the total amount was in my wallet at the time of that deposit, and finishing with profit/loss since I began).

The formula I need is for profit/loss since starting.

I figure this value is “Total Amount After Deposit” minus the SUM of all values in the “Converted” field (which are all deposits converted from EUR to USD on the investment platform, i.e. Converted1, Converted2, etc)…

So how do I get the SUM of ALL Converted values into the formula?

(See screenshot for reference)

Any questions/clarification required, please let me know.

Thanks!
Christopher

Screenshot 2021-07-28 at 09.15.23

1 Solution

Accepted Solutions
Raminder_Singh
7 - App Architect
7 - App Architect

Hi @Torus_Global,

You can’t. Unlike excel, formulas can reference cells from only one row at a time. What you can do is to calculate the profit for each row and then sum the profit column by looking at the status bar at the bottom of the table:

image

See Solution in Thread

1 Reply 1
Raminder_Singh
7 - App Architect
7 - App Architect

Hi @Torus_Global,

You can’t. Unlike excel, formulas can reference cells from only one row at a time. What you can do is to calculate the profit for each row and then sum the profit column by looking at the status bar at the bottom of the table:

image