Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    50

    Unanswered: Sum (Fld,CondFld,Cond) can you have 2 CondFld

    Hi There

    Can anybody tell me if you can have 2 condition fields when you use SUM function in a formula this is why i ask .

    This is my Formula

    SUM ({HotelSum > 75.Total Rnts},{HotelSum > 75.Rate})

    But i want it to do

    SUM ({HotelSum > 75.Total Rnts},{HotelSum > 75.Rate}) but also with this
    condition in it as well {L/P} = "P"

    So i want it to Sum up the {total rnts} for each {rate group} with the {class of "P"}

    Does that make sense hope it does

    Regards

    KM

  2. #2
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    23
    Why don't you make it by steps, for example one function:

    If {Field} = 'P' Then
    {FieldNumber}
    Else
    0

    You can build functions for summarize with every other function.

    Sneaky Pie

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •