Skip to Content
0
Former Member
Jul 02, 2007 at 03:07 PM

SUM conditional Field

22 Views

Post Author: leedo

CA Forum: .NET

Hi,I am a bit lost here and need some help. I have the following fields in my report:- Called Number<Text>- Rate<Number>- Duration <Number> - Price<Formula> => Rate * DurationNormally to simply sum the "Price" field I'd write: =>SUM({Cost_report.Calls})However,

I need to create two Summary fields. Each one only sums a subset of the

the "Price" column based on a condition in the "CalledNumber" column as

follows:CalledNumber Price----


-


97184323 2.592343323 23.0084755543 30.583343321 8.094532234 10.5 Sum for only numbers that begin with 9==> 36.00Sum for only numbers that begin with 8==> 38.5Any ideas?!!!Please used VB Syntax if possible.Thanks