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

1. Registered User
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. Registered User
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
•