Ask Your Question
0

Multiple operations in Calc returns Err:504

asked 2019-12-02 12:16:32 +0100

Paul Stace gravatar image

Using multiple operations in Calc with a DSUM formula returns Err:504 for every cell. The idea is to summarise data by two factors (in the attached example, summarising expenses by person and item). This works correctly in Excel (as a data table), but not in Calc. Is this a bug, or something different in Calc? C:\fakepath\Untitled 1.ods

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-12-02 15:36:36 +0100

erAck gravatar image

Not sure the MULTIPLE.OPERATIONS() function is even supposed to work like that. In Excel the Table thing might, but..

Use a pivot table, i.e. select/mark the data range, then menu Data -> Pivot Table -> Insert or Edit, confirm Current selection, drag Item to Row Fields, Who to Column Fields and Amount to Data Fields, hit OK. (or set a different destination starting cell first to have the pivot table on the same sheet).

edit flag offensive delete link more

Comments

I can't see the MULTIPLE.OPERATIONS() function available in calc wizard neither in the help .

m.a.riosv gravatar imagem.a.riosv ( 2019-12-02 22:50:31 +0100 )edit

Thanks for the answer. In this case, I didn't want to use Pivot Table as I wanted to manually control the row and column field values (including having some values that didn't occur in the data). Looks like I'm stuck with Excel, unfortunately.

Paul Stace gravatar imagePaul Stace ( 2019-12-04 05:51:15 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-02 12:16:32 +0100

Seen: 30 times

Last updated: Dec 02