Count IF

[Nikhil2725]

Hi All,

I have measure like:

Num(round(rangesum(above(total sum(GrossValue_LC),0,RowNo(total))))/
round(sum(total Aggr(sum(GrossValue_LC),PH6)))*100,'##.00')

Here I will get the Output in Percentage like(7.47%,14.49%,20.14%,80.56%,85.66%,87.99%)

Now my question is like I want count of percentage greater than 80.00% how can i Do it???..

Kindly Help Me...

[Nikhil2725]

HI Sunny, in the below expression i need to filter from the billing year as well.

Billing year will be 2010,2011 and 2012.. This Billing year I have applied in the Filter...

Sum(Aggr(

If(Num(round(rangesum(above(total sum(GrossValue_LC),0,RowNo(total))))/
round(sum(total Aggr(sum(GrossValue_LC),PH6)))*100,'##.00') > 0.80, 1, 0)

, (Key, (=Sum(GrossValue_LC), desc))))

Load Script...

Data:
LOAD
PH6&'|'&PH6_desc&'|'&"Division" as Key
Resident Data_temp;

[Nikhil2725]

Attached the Screenshot for the reference....

[sunny_talwar]

I don't really understand... are you able to share a sample where we can look at this?