https://bugs.documentfoundation.org/show_bug.cgi?id=134234
--- Comment #4 from Joel Madero <[email protected]> ---
Xisco - I'm not sure the title accurately gets the issue (SUM). Look at column
E on "Current Portfolio Analysis". There isn't a SUM value there. The formula
is:
=SUMPRODUCT(--($'Trade Ledger'.$C$2:$'Trade Ledger'.$C$10000=A2),--($'Trade
Ledger'.$B$2:$'Trade Ledger'.$B$10000="Buy"),$'Trade Ledger'.$I$2:$'Trade
Ledger'.$I$10000,$'Trade Ledger'.$E$2:$'Trade Ledger'.$E$10000)/SUMIFS($'Trade
Ledger'.$E$2:$'Trade Ledger'.$E$10000,$'Trade Ledger'.$C$2:$'Trade
Ledger'.$C$10000,A2,$'Trade Ledger'.$B$2:$'Trade Ledger'.$B$10000,"Buy")
There is SUMPRODUCT and SUMIFS but no just SUM.
Just wanted to point it out. Updated my git pull today and notice that the
problem is still there. Going to revert that patch from Noel to confirm that
the issue goes away.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
