Creating a Measure for the Absolute Value?

02-02-2010, 12:08 PM
Hello,
I was hoping that I would be able to create a measure returning the absolute value of a returned sum

So far I have this code
mb.AddField(New MeasureBuilder("Total cost Absolute").SetAggregateFunction(AggregateFunction.Sum) _
            .SetExpression(Of Integer)("=Fields!TransactionQty.Value * Fields!UnitCost.Value") _
            .SetDefaultFormat("c") _
            .SetForeColor(Color.DarkBlue))

is there a way to do this?
Thanks
Robert

Re: Creating a Measure for the Absolute Value?

02-04-2010, 9:00 AM
Robert,

I apologize for the delayed response.

It should be as simple as wrapping the expression with Abs function:

"=Abs(Fields!TransactionQty.Value * Fields!UnitCost.Value)"



-Jon