Sum only the negative numbers in a column

[pnelsonmi]

Hello,

Thank you for taking time to review my question. I am certain I am missing something simple, but can't identify it. 

We have data that is collected via forms. The form data is stored in the Forms Data Table. There are multiple forms within this table and each form has multiple fields.

Question: How do I sum only the negative numbers within the FieldValue column?

FormName	FieldCaption	FieldValue
Property Valuation Data	Value ($)	-205973
Property Valuation Data	Value ($)	-32257
Property Valuation Data	Value ($)	-36994
Property Valuation Data	Value ($)	11739
Property Valuation Data	Value ($)	11880
Property Valuation Data	Value ($)	14808

Thank you for your assistance!

Patrick

[mlsx4 · Accepted solution]

Hi  @pnelsonmi 

You can do something like this:

Measure = CALCULATE(SUM(MyTable[FieldValue]),MyTable[FieldValue]<0)

[pnelsonmi]

Thank you for your assistance!

[tamerj1]

Hi @pnelsonmi 

Which column identifies the rows? Is this a sample of source data or a table visual?

[pnelsonmi]

Hello,

Thank you for your reply.  If I am following you, the FieldValue column contains the row data.  This is sample source data. I was not able to upload an attachment of the Excel file.  Please advise if there is a way to provide a better sample.

Patrick