Percentage calculation Help

[pawwy1415]

Hi Experts,

Can any one please help me on below issue.

Left hand Low% is calculated as like below

=(Count({<[Year]={$(=Max([Year])-1)},

[Rating]={'Low'}>}distinct [ID]))/

(Count({<[Year]={$(=Max([Year])-1)},[Rating]={'Low'}>}distinct [ID])+Count({<[Year]={$(=Max([Year])-1)},[Rating]={'High'}>}distinct [ID])+

Count({<[Year]={$(=Max([Year])-1)},[Rating]={'Medium'}>}distinct [ID]))

Right hand Low% is calculated as like below

=(Count({<[Year]={$(=Max([Year])-1)}>}distinct [ID])/(Count({<[Year]={$(=Max([Year])-1)}>}total distinct [ID])

but both values are not matching

Please help me on this.

Thanks in advance

[olivierrobin]

hello

the expression are not the same

in the 1st, you take only 'low' values as numerator and in the 2nd one, you take all values

try to add the same set analysis in both

[sasiparupudi1]

May be try

Avg(Aggr((Count({<[Year]={$(=Max([Year])-1)}>}distinct [ID])/(Count({<[Year]={$(=Max([Year])-1)}>}total distinct [ID]),

MonthYear)

)

[pawwy1415 · Accepted solution]

The below expression is working fine

=(Count({<[Year]={$(=Max([Year])-1)},

[Rating]={'Low'}>}distinct [ID]))/

(Count({<[Year]={$(=Max([Year])-1)},[Rating]={'Low'}>}total distinct [ID])+Count({<[Year]={$(=Max([Year])-1)},[Rating]={'High'}>}total distinct [ID])+

Count({<[Year]={$(=Max([Year])-1)},[Rating]={'Medium'}>}total distinct [ID]))