AnsweredAssumed Answered

Q: Using Calculation with Summary

Question asked by lcot17 on Feb 29, 2016
Latest reply on Mar 10, 2016 by beverly

I am attempting to 'SUMIF' a table column (if it were excel - but it isn't).

 

I want to create a calculation that SUMS ALL RECORDS THAT MATCH A CRITERIA


Table to Calculate:

TABLE NAME: TRANSACTIONS

FromAmount
Customer10
Agent5
Agent20
Customer10
Customer20
Customer10

 

What is the calculation formula to 'SUM' the TRANSACTIONS::Amount where the TRANSACTIONS::From = "Customer" ?

 

Currently, in the Transactions table I have a summary field to 'SUM' the totals of the Amount column.

 

In the table where I want the calculation to output, so far I have tried 'If', 'Sum', 'Case', 'GetSummary'.

 

Can someone help??

Outcomes