AnsweredAssumed Answered

Use two summary fields in a calculation

Question asked by twelvetens on Mar 5, 2015
Latest reply on Mar 6, 2015 by keywords

Hi,

 

I have a table of stock transactions.

Each record has a quantity, and a type:

Stock IN

Stock OUT

Loan IN

Loan OUT

....And a depot

....and various other fields.

 

 

I've got two summary fields:

 

Summary of StockIN (total of quantity of any record which is of type Stock IN)

Summary of StockOUT (total of quantity of any record which is of type Stock OUT)

 

I want another calc to show the "Summary of Stock IN" less "Summary of Stock OUT", so that I can show the "Summary of Stock Current", and I want to be able to show this in multiple summary parts, depending on what fields the table has been sorted by.

 

I can't get the summary fields to work in calculations, and I'm banging my head against the GetSummary function.

 

Can anyone help?

Outcomes