- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 31, 2024 05:18 PM
I'm stuck. I need a field type and formula to display the cumulative annual profit or loss (P/L) displayed as a percentage (%) and based on a Q1 starting amount and subsequent amounts entered in Q2, Q3, & Q4 fields.
This seemed easy until I got started. Now I'm digging a mental hole I can't climb out of :-). Help... thank you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 31, 2024 07:59 PM
Could you provide screenshots of your table setups and some example data with expected output?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 01, 2025 03:27 AM
I believe this is the correct layout and output (Notes field). Thank you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 01, 2025 07:30 AM
FYI, $amounts in Q1, Q2, etc. are quarterly beginning amounts for the total account value/balance. The purpose of the % P/L field is only to display the current cumulative % of profits or loss for the quarters reported.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 01, 2025 04:53 PM
Hmm and so it's always based off of the value in 'Q1'? Does this look right?
 
IF(
Q4,
(Q4-Q1)/Q1,
IF(
Q3,
(Q3-Q1)/Q1,
IF(
Q2,
(Q2-Q1)/Q1
)
)
)
