Calculating sum based on a condition.

[#1]

Hi,

I'm trying to find the sum of a field based on a condition that is given to another field.

example- Sum(No.of.Customers) if(Day>3 AND Day<5)

Field names-No.of.Customers and Day.

Can some one help me clear this.

[MK_QSL · Accepted solution]

COUNT({<Day = {">=3<=5"} >}Customer)

or

SUM({<Day = {">=3<=5"} >}Customer)

[#3]

That worked well, thank you so much.

[#4]

I'm using this expression:

Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'##.00')

Can you tell me how to add '%' to it at last.

example- 12.45%

[MK_QSL]

Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'#0.00%')

[#6]

When I use:

Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'##.00')

The value I get is : 28.53

But when I use :

Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'#0.00%')

It becomes : 2852.87%

[MK_QSL]

Sorry.. Remove * 100

[#8]

Thank you very much.