Data Dynamics Analysis Support

Started by bobalicious at 02-02-2010 12:08 PM. Topic has 1 replies.

Print Search Rate
Sort Posts:    
   02-02-2010, 12:08 PM
bobalicious is not online. Last active: 7/2/2010 10:13:34 PM bobalicious

Not Ranked
Joined on 06-22-2009
Posts 9
Creating a Measure for the Absolute Value?
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

   Report 
   02-04-2010, 9:00 AM
Jon Smith - DD is not online. Last active: 2/10/2012 4:28:33 PM Jon Smith - DD

Top 25 Posts
Joined on 02-21-2007
Raleigh, NC
Posts 958

DDStaff
Re: Creating a Measure for the Absolute Value?
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

   Report 
GrapeCity » Product Support » Data Dynamics A... » Re: Creating a Measure for the Absolute Value?

Privacy Policy | Copyright © 1997-2012 — GrapeCity, inc.
All trademarks mentioned are the property of their respective owners.