4 Replies Latest reply: May 15, 2014 9:56 AM by Grant Perkins

# Sum

Hello, I'm searching for the sum (like in excel e.g. =Sum(a1:A8)

Is there a equal function ?

greetings oli

• ###### Sum

Hi Oli,

Not exactly!!

If you want to add numeric columns in a table, create a formula based calculated field and use the expression field1field2field3+field4   etc etc. . .

If you want to add down the page, you’ll need to create a summary.  You can add subtotals by double clicking on the key field and use the options in the display tab.

I hope this quick answer helps out a bit.  If you want more details, just ask.

Regards

Steve

• ###### Sum

Hi Steve,

I want to make a summary horizontal:

A B C D

1

2

3

In Excel I can use: Sum(A1:D1). What can I do in Monarch ?

greetings Oli

• ###### Sum

In that example, you'd make a calculated field and put in the following equation:

ABC+D

You would get the sum of those four fields for every row.

• ###### Sum

Originally posted by OJGraf:

Hi Steve,

I want to make a summary horizontal:

A B C D

1

2

3

In Excel I can use: Sum(A1:D1). What can I do in Monarch ?

greetings Oli /b[/quote]Oli,

If the A, B, C, D columns represent different values of the same field you could set the field to display ACROSS in the summary and then select the count format/method(s) that you wish to report. This will enable both horizontal and vertical summation.

If the columns do not currently represent values of the same field it may be possible to make a 2 stage process in Monarch where the first stage re-groups the data to make the analysis possible by the second part of the process.

Apoligies if I have not understood your requirements correctly.

Grant