Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
COUNT({<Day = {">=3<=5"} >}Customer)
or
SUM({<Day = {">=3<=5"} >}Customer)
COUNT({<Day = {">=3<=5"} >}Customer)
or
SUM({<Day = {">=3<=5"} >}Customer)
That worked well, thank you so much.
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%
Num((((SUM({<Day = {">=3<5"} >}[No of Customers]))/(Sum([No of Customers])))*100),'#0.00%')
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%
Sorry.. Remove * 100
Thank you very much.