formula help

building reports webintelligence
1

I used a section and a break to find total paid amount per customer for a given time interval.

The formula I used is: =Sum([Total Paid Amount])

How can I modify the above formula to show only the sum that are grater or equal to 15000?

TIA,
Regards,

ocm (BOB member since 2011-02-16)

2

Please can you clarify the requirement?

Do you only want to show customer totals greater than 15000 or only sum up the lines that are greater than 15000? They would need different formula.

3

Mark,

Thank you. Though I would like to learn both formulas, I only want to display customer total greater & equal to 15000 in my report.

Regards,

OCM

ocm (BOB member since 2011-02-16)

4

This will give you the total amount for a customer:

=Sum([Total Paid Amount]) in ([Customer])

Call it Customer Total Paid

Then you can create a filter variable:

=If([Customer Total Paid] > 15000;“Y”;“N”)

Then you can filter on that variable and keep the Ys.

5

Mark,

Many thanks. The formula worked beautifully.

I created input controls and applied my filter there (choose only “Y”).
Regards,

ocm (BOB member since 2011-02-16)