Newbee Problem 2

[WillBoss]

Hi

I have created a report but I have to write a formula to calculate a total pr all products with specific codes.

My problem is that I cant do it!!

Here is what I have done

if {AllCustomerProducts.type} = "Plan24" Then
Sum ({AllCustomerProducts.balance})

Basically what I want is to get a balance for all people with 'Plan24'.

Can anyone assist??

Cheers
Will

 

[lbass]

Change the formula to:

if {AllCustomerProducts.type} = "Plan24" Then
{AllCustomerProducts.balance}

Then right click on this formula and insert a sum.

You might also consider inserting a crosstab where you add the type field as a row or column field and sum of balance as the summary. Then you won't need separate formulas per type.

-LB

 

[synapsevampire]

Another simple approach is to insert a running total and use the criteria in the evaluate->use a formula, in your case select sum as the type and place:

{AllCustomerProducts.type} = "Plan24"

-k

 

[WillBoss]

Hi guys

lbas when you say 'Then right click on this formula and insert a sum.' what do you mean. I inserted the formula you suggested.

 

[synapsevampire]

LB meant place the formula in the details, then right click it and select insert->summary.

Then you can delete it from the details afterwards if you desire.

-k

 

[WillBoss]

Hi all, Sorry for only getting back to you now.

Yes that did the trick. Thanks a million.