Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi <
I have Organization ,Bucket,Month Year are Dimensions
Count(employee Number ) as Expression
i want to calculate Compliance % in Grand Total(Dimensionality()=0)
Jan 2016 i want to show (96/102)*100=94%
Please find the attached Data Set
Like this?
=Num(Aggr(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)), MonthBucket),'#,##0.00%')
May be this:
If(Dimensionality() = 0, Count({<Bucket = {'On_Time'}>} [employee Number])/Count([employee Number]), Count([employee Number]))
Hi Sunny,
Thanks for your Time
Iam using similar expression But iam Getting 98.97% instead of 94% for JAN2016
i want to show distinct count so i used distinct in expression
Please find the attached QVW.
Thanks,
Joshi
In that case, try this:
if(dimensionality()=0,
Num(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)),'#,##0.00%')
,count(DISTINCT Employee_Number))
Hi Sunny ,
its working when its grand Total area.
But i want the same Compliance % as A Calculated Dimension area.
How to achieve same
please find the QVW
Thanks,
Joshi
Like this?
=Num(Aggr(Count(DISTINCT{<Bucket={On_Time}>}Employee_Number)/Sum(Aggr(Count(DISTINCT Employee_Number), Org_Hier.ORGANIZATION, Bucket, MonthBucket)), MonthBucket),'#,##0.00%')