Method Community

Is there a way to have a calculated field that looks at 3 other fields on the report to calculate the total of those three fields?  For example, I have an Opening balance field, a total Charges field and a total received field.  I want to calculate the ending balance by taking the opening balance, subtracting the amount in the charges field and adding the amount in the received field.

Thanks!

Hi Karen,

I'm assuming the other fields are field on screen?  If so, I would put this calculated field in whatever table/screen this report is generated from.  If you don't need the field on screen, you can hide it.  You can then do the calculations on screen, using the Basic Math Calculation actions. Then just use the field in the report like you would any other field.

Hope this helps,

- Adam

Adam,

No, actually I was hoping there was a way to add values in fields on the report together - but it seems like this is not possible.  They are not fields in a Method table/screen.  They are label fields on the report that are summing the amount field from Method.  I want to add 3 "sums" together.

Karen

Hi Karen,

You could use calculated fields in the Report Designer.  Just right click on the table at the top right of the designer and add a calculated field.  You can then create an expression to add the values of the fields you want.  It should look like this:

First right click to add the field, then right click again and edit the expression.  The rest is pretty straighforward, just select your fields and the operators.

- Adam

Thanks Adam, but as I already said, they are REPORT fields, not Method fields, so they do not show up in the fields list as fields that I can calculate with.  If there is a way to calculate on REPORT fields I would love to hear it!

To clarify,  what I have done in my report is used 3 label fields to add together three different amount fields from three different Method tables.  I am hiding the 3 detail columns and so all you see on the report are three totals - Beginning Balance, Total Receipts, and Total Charges.  I want to now take the value in the Beginning Balance REPORT field (which is a sum of a hidden field), add the Total Receipts (another sum of a hidden field) and subtract the Total Charges (third sum of a hidden field) to get Ending Balance.  

Thanks!

Karen

Karen,

Sorry for the misunderstanding.  I was doing some research and found this post that explains how to add summary fields together.  Is this what you may be looking for?

- Adam